In our organization, we are running multiple databases on the same box on
the default port. However, they all have their own data directories and they
listen on different VIP's. Here are the parameters in postrgresql.conf to
make it work:
unix_socket_directory = 'data directory for a particular DB
Hello everybody!
I have many app servers using connection pooling. At any time, there are
about 1000 total connection to the database from all the app servers;
however, only few random connections are active.
The application often executes relatively big sorts. The work_mem size is
32MB, and event
.
So, eventually enough sessions get big work memory allocated to starve the
Linux out of memory.
My physical memory size is 32GB,
Shared_buffers = 2GB
On 6/15/09 2:13 PM, "Scott Marlowe" wrote:
> On Mon, Jun 15, 2009 at 2:15 PM, Igor Polishchuk wrote:
>> Hello everybody!
>
Alvaro,
Why don't you just create a sql script with a separate vacuum command for each
table you need to vacuum?
-Original Message-
From: pgsql-admin-ow...@postgresql.org on behalf of Anj Adu
Sent: Sun 11/1/2009 8:03 AM
To: Alvaro Herrera
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADM
