| From: | "Iain" <iain(at)mst(dot)co(dot)jp> |
|---|---|
| To: | "'Edoardo Ceccarelli'" <eddy(at)axa(dot)it> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: R: slow seqscan after vacuum analize |
| Date: | 2004-02-05 06:32:29 |
| Message-ID: | 006401c3ebb1$d4237c60$7201a8c0@mst1x5r347kymb |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> Yes, you are right but it wasn't the case this time, I have run the
explain plenty of
> times with same results. I think that the reason was that I made a simple
VACUUM,
> after a VACUUM FULL ANALYZE (1h!!) things are ok
It's reasonable to expect that a seq scan will perform faster after a full
vacuum, as the physical size and organization of the table has been changed.
I wouldn't expact a plain vacuum to have any tangible affect on performance,
for the better or for the worse..
I'd like to know more about the possibility of plain vacuums harming
performance. This is the first I've heard of it. Vacuum full is not always
an option in a production environment.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2004-02-05 13:15:24 | Re: R: slow seqscan after vacuum analize |
| Previous Message | Christopher Browne | 2004-02-05 04:18:39 | Re: R: R: slow seqscan after vacuum analize |