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.
In response to
pgsql-performance by date
|Next:||From: Ondrej Ivanič||Date: 2011-08-30 08:20:08|
|Subject: Re: Query optimization help|
|Previous:||From: Scott Marlowe||Date: 2011-08-30 06:39:43|
|Subject: Re: Re: How to track number of connections and hosts to