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 intended

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 Objects, no

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 doing

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

Re: [ADMIN] Large files in main/base

2010-07-10 Thread Tom Lane
Guillaume Lelarge guilla...@lelarge.info 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