Quick Links

Re: queries are fast after dump->restore but slow again after some days dispite vacuum

From:	Felix Scheicher <mandavi(at)web(dot)de>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Date:	2012-07-19 15:13:14
Message-ID:	loom.20120719T160306-28@post.gmane.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Andrew Dunstan <andrew <at> dunslane.net> writes:

> Try running CLUSTER on the relevant tables and see if it makes a
> difference. If it does you might want to look into using pg_reorg
> periodically.

That worked like a charm! Many thanks. But how comes, the queries are also fast
after a restore without the cluster?

regards,
Felix

In response to

Re: queries are fast after dump->restore but slow again after some days dispite vacuum at 2012-07-19 12:38:53 from Andrew Dunstan

Responses

Re: queries are fast after dump->restore but slow again after some days dispite vacuum at 2012-07-19 15:48:46 from Andrew Dunstan
Re: queries are fast after dump->restore but slow again after some days dispite vacuum at 2012-07-19 16:12:08 from Jeff Janes
Re: queries are fast after dump->restore but slow again after some days dispite vacuum at 2012-07-19 17:04:41 from Scott Marlowe

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Andrew Dunstan	2012-07-19 15:48:46	Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Previous Message	Tom Lane	2012-07-19 14:09:26	Re: [PERFORM] DELETE vs TRUNCATE explanation