In response to "Preeti Khurana" :
> 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 the
lines of crashing bugs
2009/6/10 Preeti Khurana :
> 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 moving to 8.3 if HOT can
he
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.or
Vick Khera writes:
> On Mon, Jun 8, 2009 at 9:38 AM, Preeti
> Khurana 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 isn't very aggressive by default. You m
On Mon, Jun 8, 2009 at 9:38 AM, Preeti
Khurana 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 update/delete programs so that it runs
af
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 2:38 PM, Preeti
Khurana 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.
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)
