Re: [ADMIN] Large files in main/base

2010-07-10 Thread Neuber, Dirk
>> What is it? > Why don't you tell us? > The exact name of the file might be useful information, too. It is : postgres/8.3/main/base/16385/2613 Thanks. Ciao Dirk. DISCLAIMER: Unless indicated otherwise, the information contained in this message is privileged and confidential, and is intend

Re: [ADMIN] Large files in main/base

2010-07-10 Thread Guillaume Lelarge
Le 10/07/2010 12:43, Neuber, Dirk a écrit : >>> What is it? > >> Why don't you tell us? > >> The exact name of the file might be useful information, too. > > It is : postgres/8.3/main/base/16385/2613 > This is a system catalog, pg_largeobject, which holds binary objects. If you use Large Objec

Re: [ADMIN] Postgresql shared_buffer and SHMMAX configuration

2010-07-10 Thread Gnanakumar
> Not to the database itself, you don't; and it's probably killing > performance for you to try to do that. You should use your > connection pooler to funnel that many client-side connections down > to a much smaller number of database connections. Your pgpool > configuration doesn't seem to be d

Re: [ADMIN] High Availability: Hot Standby vs. Warm Standby

2010-07-10 Thread Greg Smith
Thomas Kellerer wrote: I'm wondering about the differences when the failover situation occurs. From reading the docs, I get the impression that 9.0's streaming replication might be faster than 8.4's WAL shipping, but otherwise offers the same level of data protection. Is there a difference in h

Re: [ADMIN] Large files in main/base

2010-07-10 Thread Tom Lane
Guillaume Lelarge writes: > Le 10/07/2010 12:43, Neuber, Dirk a écrit : >>> The exact name of the file might be useful information, too. >> >> It is : postgres/8.3/main/base/16385/2613 > This is a system catalog, pg_largeobject, which holds binary objects. If > you use Large Objects, no wonder t