08, 2009 9:59 PM
To: Preeti Khura
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres's Performance degrades after heavy db operation
oh, and take the time to upgrade to newest 8.1.X as the matter of urgency!.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
2009/6/10 Preeti Khurana preeti.khur...@globallogic.com:
I checked the release notes till 8.1.17, but could not come across any such
issue which leads to db performance degradation after doing heavy db
operations. AutoVacuum is also enabled parallel.
Note that you might be much better served
In response to Preeti Khurana preeti.khur...@globallogic.com:
I checked the release notes till 8.1.17, but could not come across any such
issue which leads to db performance degradation after doing heavy db
operations.
I don't think that was his point. I expect it was something more along
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)
On Mon, Jun 8, 2009 at 2:38 PM, Preeti
Khuranapreeti.khur...@globallogic.com 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
oh, and take the time to upgrade to newest 8.1.X as the matter of urgency!.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 8, 2009 at 9:38 AM, Preeti
Khuranapreeti.khur...@globallogic.com wrote:
Any ideas/pointers on what could be making the DB slow after all these heavy
operations being performed?
It seems autovacuum is not running often enough. You may wish to
include vacuum in your data
Vick Khera vi...@khera.org writes:
On Mon, Jun 8, 2009 at 9:38 AM, Preeti
Khuranapreeti.khur...@globallogic.com wrote:
Any ideas/pointers on what could be making the DB slow after all these heavy
operations being performed?
It seems autovacuum is not running often enough.
8.1's autovacuum