| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | marie(dot)tuite(at)edisonaffiliates(dot)com |
| Cc: | josh(at)agliodbs(dot)com, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: sloooow query |
| Date: | 2002-10-07 20:57:40 |
| Message-ID: | 26239.1034024260@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
"Marie G. Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com> writes:
> I pg_dumped the first database having performance problems and reloaded it
> into a new database on the same server. The query ran normally when I
> reloaded it. There is no difference in hardware, schema or anything else.
Have you done an ANALYZE or VACUUM ANALYZE in either database? The
statistics the planner is working from seem to be quite different
in the two plans.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-10-07 21:00:57 | Re: sloooow query |
| Previous Message | Robert Treat | 2002-10-07 20:52:16 | Re: sloooow query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-10-07 21:00:57 | Re: sloooow query |
| Previous Message | Robert Treat | 2002-10-07 20:52:16 | Re: sloooow query |