On Mon, Jun 8, 2009 at 2:38 PM, Preeti Khurana<preeti.khurana@xxxxxxxxxxxxxxx> wrote: > Hi, > > I am using Postgresql 8.1.2 and performing quite a huge number of db > operations ( insert/update/ delete) in around 4 tables. Around 3 million of > db is inserted and then 600 K rows are updated for around 5-6 times during a > day. Its observed that running this process for few days ( 5-6 days) makes > the db access quite slower. Auto-Vacuum is set to ON with other parameters > set to default. > > > > Slony 1.1.5 is being used for the db replication simultaneously. > > > > Any ideas/pointers on what could be making the DB slow after all these heavy > operations being performed? check if vacuum analyze says anythihing about FSM size being too small. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
