Re: [GENERAL] postgres getting slow under heavy load though autivacuum is enabled

2009-06-09 Thread Vick Khera
2009/6/9 Grzegorz Jaśkiewicz : > The slony tables perhaps should be vacuumed too. > slony vacuum's its own tables as necessary. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] postgres getting slow under heavy load though autivacuum is enabled

2009-06-09 Thread Dimitri Fontaine
Bill Moran writes: > In response to "tamanna madaan" : >> >> I am using postgres 8.1.2 with slony 1.1.5 used for replication >> between two nodes. Very high number of db operations like (2.8 >> million inserts, 1.4 million update and 4.5 lakhs deletes.) are being >> done on db in one transaction

Re: [GENERAL] postgres getting slow under heavy load though autivacuum is enabled

2009-06-09 Thread Bill Moran
In response to "tamanna madaan" : > > I am using postgres 8.1.2 with slony 1.1.5 used for replication between two > nodes. Very high number of db operations like (2.8 million inserts, 1.4 > million update and 4.5 lakhs deletes.) are being done on db in one > transaction and this is repeated for

[GENERAL] postgres getting slow under heavy load though autivacuum is enabled

2009-06-09 Thread tamanna madaan
Hi I am using postgres 8.1.2 with slony 1.1.5 used for replication between two nodes. Very high number of db operations like (2.8 million inserts, 1.4 million update and 4.5 lakhs deletes.) are being done on db in one transaction and this is repeated for 5-6 times a day at an interval of let

Re: [GENERAL] postgres getting slow under heavy load though autivacuum is enabled

2009-06-09 Thread Grzegorz Jaśkiewicz
On Tue, Jun 9, 2009 at 9:37 AM, tamanna madaan wrote: > Hi > > I am using postgres 8.1.2 with slony 1.1.5 used for replication between two > nodes. Very high number of db operations like (2.8 million inserts, 1.4 > million update and 4.5 lakhs deletes.) are being done on db in one > transaction and