full vacuum really slows down query
This is a discussion on full vacuum really slows down query within the Pgsql General forums, part of the PostgreSQL category; --> I have a query that takes 2 sec if I run it from a freshly restored dump. If I ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
06-05-2008, 06:40 PM
| ||||
| ||||
 full vacuum really slows down query I have a query that takes 2 sec if I run it from a freshly restored dump. If I run a full vacuum on the database it then takes 30 seconds. Would someone please comment as to why I would see a 15x slow down by only vacuuming the DB? I am using 8.3.1 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general      |
 |
« Database growing. Need autovacuum help.
|
Tripping up on my first attempt at building PG from source »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:29 PM.
