Re: copy command and blobs - Mailing list pgsql-performance

From Robert Haas
Subject Re: copy command and blobs
Date
Msg-id AANLkTi=jZ6E76PPPNFeT1FUWD+=AeYa-ZdrMQ1jBAX5u@mail.gmail.com
Whole thread Raw
In response to Re: copy command and blobs  (Madhu Ramachandran <iammadhu@gmail.com>)
Responses Re: copy command and blobs
List pgsql-performance
On Fri, Jan 21, 2011 at 5:10 PM, Madhu Ramachandran <iammadhu@gmail.com> wrote:
> i was looking at
> http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html
> when they talk about using OID type to store large blobs (in my case .jpg
> files )

It's probably worth noting that that document is 9 years old.  It
might be worth reading something a little more up-to-date.  Perhaps:

http://www.postgresql.org/docs/current/static/largeobjects.html

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Madhu Ramachandran
Date:
Subject: Re: copy command and blobs
Next
From: Achilleas Mantzios
Date:
Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2