Le 27/03/2010 14:00, Gnanakumar a écrit :
> [...]
> We're using PostgreSQL 8.2. Recently, in our production database, there was
> a severe performance impact.. Even though, we're regularly doing both:
>
> 1. VACUUM FULL ANALYZE once in a week during low-usage time and
>
> 2. ANALYZE eve
You may want to consider performing more frequent vacuums a week or really
considering leveraging autovacuum if it makes sense to your transactions
volume.
Regards,
Husam
-Original Message-
From: Gnanakumar
Sent: Saturday, March 27, 2010 6:06 AM
To: pgsql-admin@postgresql.org
Hi,
We're using PostgreSQL 8.2. Recently, in our production database, there was
a severe performance impact.. Even though, we're regularly doing both:
1. VACUUM FULL ANALYZE once in a week during low-usage time and
2. ANALYZE everyday at low-usage time
Also, we noticed that the
