If speed (add/get) is the only concern, image files could be big (~10M),
and database only serves as storage. In the postgresql 8, which type
(bytea vs large object) is the preferred one? Is it true, in general,
that bytea inserts is slower?

Thanks.
johnl

Search Discussions

  • Weiping at Apr 11, 2005 at 1:18 pm
    I think bytea is a little bit slower then large object.

    Regards

    Laser
    If speed (add/get) is the only concern, image files could be big (~10M),
    and database only serves as storage. In the postgresql 8, which type
    (bytea vs large object) is the preferred one? Is it true, in general,
    that bytea inserts is slower?

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedApr 6, '05 at 7:34p
activeApr 11, '05 at 1:18p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

John Liu: 1 post Weiping: 1 post

People

Translate

site design / logo © 2021 Grokbase