| From: | Szymon Kosok <szymon(at)mwg(dot)pl> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query optimization help |
| Date: | 2011-08-30 07:44:10 |
| Message-ID: | CAOJGGcFnW9+shK3q7UZ24M51Japhny_zp+OsdqpkcRWFxS_kcQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
2011/8/30 Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>:
> Could you please re-post your explain using this web site:
> http://explain.depesz.com/ and post links to Stackoverflow question?
Here it is: http://explain.depesz.com/s/Iaa
> - try to disable nested loop join (set enable_nestloop=off)
Even worse performance (http://explain.depesz.com/s/mMi).
My configuration:http://pastie.org/2453148 (copied and pasted only
uncommented important variables). It's decent hardware. i7, 16 GB of
RAM, 3x2 RAID 10 (7200rpm) for OS + data, RAID 1 (2 disks, 7200rpm)
for WAL, RAID controller with BBU and 512 MB memory cache (cache is
set to write only).
PS. Sorry Ondrej, accidentally I've sent reply to you, not to list.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ondrej Ivanič | 2011-08-30 08:20:08 | Re: Query optimization help |
| Previous Message | Scott Marlowe | 2011-08-30 06:39:43 | Re: Re: How to track number of connections and hosts to Postgres cluster |