Re: DB is slow until DB is reloaded

Steve Crawford wrote:
> Madison Kelly wrote:
>> Hi all,
>>
>> I've got a fairly small DB...
>>
>> It slows down over time and I can't seem to find a way to get the
>> performance to return without doing a dump and reload of the database...
>
> Some questions:
>
> Is autovacuum running? This is the most likely suspect. If not, things
> will bloat and you won't be getting appropriate "analyze" runs. Speaking
> of which, what happens if you just run "analyze"?
>
> And as long as you are dumping and reloading anyway, how about version
> upgrading for bug reduction, performance improvement, and cool new
> features.
>
> Cheers,
> Steve
>

Yup, I even tried manually running 'VACUUM FULL' and it didn't help. As
for upgrading;

a) I am trying to find a way around the dump/reload. I am doing it as a
"last resort" only.
b) I want to keep the version in CentOS' repo.

I'd not tried simply updating the stats via ANALYZE... I'll keep an eye
on performance and if it starts to slip again, I will run ANALYZE and
see if that helps. If there is a way to run ANALYZE against a query that
I am missing, please let me know.

Madi