| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Marcus Engene <mengpg2(at)engene(dot)se> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!! |
| Date: | 2011-11-01 13:43:00 |
| Message-ID: | 24830.1320154980@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Marcus Engene <mengpg2(at)engene(dot)se> writes:
> After I upgraded from Postgres 8.3/8.4 to 9.0 I had all sorts of
> problems with queries with many joins. Queries that used to take 1ms
> suddenly take half a minute for no apparent reason.
Could we see a concrete test case, rather than hand waving? If there's
really a problem in 9.0, it's impossible to fix it on so little detail.
> One workaround I've done is if something looking like this....
The only way that should make a difference is if the total number
of tables in the query exceeds from_collapse_limit (or maybe
join_collapse_limit, depending on exactly how you wrote the query).
Perhaps you'd been running with nonstandard values of those settings
in 8.x, and forgot to transfer them into the new DB?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Dumoulin | 2011-11-01 14:59:41 | select where not exists returning multiple rows? |
| Previous Message | Tomas Vondra | 2011-11-01 13:13:34 | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sabin Coanda | 2011-11-01 14:01:03 | procedure takes much more time than its query statement |
| Previous Message | Tomas Vondra | 2011-11-01 13:13:34 | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |