| From: | Chris Angelico <rosuav(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help with sql |
| Date: | 2012-07-07 14:39:12 |
| Message-ID: | CAPTjJmr_iBNAXJeSw0KLJTJMye6uGPtBfjYt=e2Shqc43hFKug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Jul 7, 2012 at 11:48 PM, Perry Smith <pedzsan(at)gmail(dot)com> wrote:
> The database is mostly static. I run through a very lengthy process to populate the database maybe once a month and then it is 99% read-only.
Do you run an ANALYZE on the table after populating it? Postgres needs
up-to-date statistics for best results. I'd recommend doing an
explicit 'VACUUM ANALYZE' once your data's loaded, and then try your
queries after that - it might not do much, but it also might give a
massive improvement.
ChrisA
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-07-07 16:09:23 | Re: BUG? Regular expression matching of optional character group at beginning of RE |
| Previous Message | Perry Smith | 2012-07-07 13:48:06 | Re: Help with sql |