Bytea(TOAST) vs large object facility(OID)

Поиск
Список
Период
Сортировка
От kosalram Babu Chellappa
Тема Bytea(TOAST) vs large object facility(OID)
Дата
Msg-id 1387829794.22036.YahooMailNeo@web181404.mail.ne1.yahoo.com
обсуждение исходный текст
Ответы Re: Bytea(TOAST) vs large object facility(OID)  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-performance
Hi,
 We have a requirement to store images/documents with an average size of 1-2MB on PostgreSQL database. We have PostgreSQL 9.2.4 running on Red hat linux 64 bit. We decided to setup a stand alone postgreSQL server without streaming replication to host the images/documents only. We are new to postgreSQL and we heard a lot of conversation about using Bytea vs Large object facility. We would be inserting and retrieving document as whole using java webservices call from hibernate/JPA interface into postgreSQL database. Is there any performance benchmark when using ByteA vs Large object facility? Is there a general guidance to use one of these?

Thanks,
Babu

В списке pgsql-performance по дате отправления:

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: slow query - will CLUSTER help?
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Optimizing a query