| From: | "Thilo Hille" <thilo(at)resourcery(dot)de> |
|---|---|
| To: | "PgSQL Novice ML" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: VACUUM ANALYSE... |
| Date: | 2003-01-16 12:36:09 |
| Message-ID: | 006601c2bd5b$d8d05240$0b00a8c0@resourcery.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> Could you run the cron job more often? That way, you'd be spreading
> the pain and each VACUUM ANALYSE would be doing less work.
It wouldnt change that much i suppose. I think the bottleneck is a table
which contains about 2.5 million records.
Even when running "vacuum analyse" twice without changing data in between
the second takes also a lot of time.
Also at night the usage of the Database is noticable less.
When starting Vacuum @daytime i can instantly watch the number of
postmasterclients and the sysload increasing very fast. Are the tables
writelocked during vaccum?
Thanks
Thilo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petre Scheie | 2003-01-16 15:00:48 | [Fwd: Re: [GENERAL] gmake check error on HPUX] |
| Previous Message | Ron Johnson | 2003-01-16 12:01:27 | Re: VACUUM ANALYSE... |