bytea vs large object in version 8

Started by John Liuabout 21 years ago2 messagesgeneral
Jump to latest
#1John Liu
johnl@stihealthcare.com

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

#2Weiping
laser@qmail.zhengmai.net.cn
In reply to: John Liu (#1)
Re: bytea vs large object in version 8

I think bytea is a little bit slower then large object.

Regards

Laser

Show quoted text

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?