Re: [PERFORM] Storing binary data.

2004-08-11 Thread Russell Smith
On Thu, 12 Aug 2004 02:29 am, Jesper Krogh wrote: > I gmane.comp.db.postgresql.performance, skrev Shridhar Daithankar: > > On Wednesday 11 Aug 2004 7:59 pm, Jesper Krogh wrote: > > > The "common" solution, I guess would be to store them in the filesystem > > > instead, but I like to have them just

Re: [PERFORM] Storing binary data.

2004-08-11 Thread Jesper Krogh
I gmane.comp.db.postgresql.performance, skrev Shridhar Daithankar: > On Wednesday 11 Aug 2004 7:59 pm, Jesper Krogh wrote: > > The "common" solution, I guess would be to store them in the filesystem > > instead, but I like to have them just in the database it is nice clean > > database and applica

Re: [PERFORM] Storing binary data.

2004-08-11 Thread Tom Lane
Jesper Krogh <[EMAIL PROTECTED]> writes: > I'd like some advise on storing binary data in the database. > Currently I have about 300.000 320.000 Bytes "Bytea" records in the > database. It works quite well but I have a feeling that it actually is > slowing the database down on queries only relate

Re: [PERFORM] Storing binary data.

2004-08-11 Thread Shridhar Daithankar
On Wednesday 11 Aug 2004 7:59 pm, Jesper Krogh wrote: > The "common" solution, I guess would be to store them in the filesystem > instead, but I like to have them just in the database it is nice clean > database and application design and if I can get PostgreSQL to "not > cache" them then it should

[PERFORM] Storing binary data.

2004-08-11 Thread Jesper Krogh
Hi. Please be a bit patient.. I'm quite new to PostgreSQL. I'd like some advise on storing binary data in the database. Currently I have about 300.000 320.000 Bytes "Bytea" records in the database. It works quite well but I have a feeling that it actually is slowing the database down on queri