From: | Philip Greer <philip(at)tildesoftware(dot)com> |
---|---|
To: | pgsql general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Why does it not use the index? |
Date: | 2003-07-21 19:33:22 |
Message-ID: | 20030721193322.GD18568@tildesoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Well duh. Crap. I remember that NOW that I've read everyones comments (thanks by the way!). I do remember reading that, and have placed the 'vacumedb -z' command in crontabs on databases in the past. Just forgot all about that - I guess it is because most of the databases I've set up on postgresql get to the point where they just simply run, and run, and run, and run. A nice thing about postgresql - wrap it in some automated maintenance and it becomes so stable it is nearly forgotten about! Vacuum analyze is one of those items where if you don't use it (manually) often, you lose it (and forget the reason why to use it).
Thanks again!
--
-----------------------------------------------------------------------------
PG.. philip(at)tildesoftware(dot)com
Law of probable dispersal: Whatever it is that hits the fan will not be
evenly distributed.
From | Date | Subject | |
---|---|---|---|
Next Message | nolan | 2003-07-21 19:46:11 | Re: Why does it not use the index? |
Previous Message | Doug McNaught | 2003-07-21 19:26:28 | Re: Why does it not use the index? |