| From: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
|---|---|
| To: | Jason Long <jason(at)octgsoftware(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Full vacuum really slowing query down |
| Date: | 2008-06-06 06:59:56 |
| Message-ID: | 4848E06C.5020206@batory.org.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2008-06-04 23:18, Jason Long wrote:
> I have a query that takes 2.5 sec if I run it from a freshly restored
> dump. If I run a full vacuum on the database it then takes 30 seconds.
1. Don't run "vacuum full", run plain "vacuum". If you run "vacuum full"
then "reindex" afterwards.
2. Run "analyze".
3. Please provide a description of your tables - schemas, how much data
there.
4. Please provide your query.
5. Please provide an output of "explain analyze [your_query]".
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Ostrowski | 2008-06-06 07:23:02 | Re: Temporary Tables and Web Application |
| Previous Message | Tom Lane | 2008-06-06 05:54:58 | Re: Re: how to clean up temporary schemas (how to sync the system table with pg_dump) |