Skip site navigation (1) Skip section navigation (2)

Re: Query optimization help

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 (view raw or flat)
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.

In response to

Responses

pgsql-performance by date

Next:From: Ondrej IvaničDate: 2011-08-30 08:20:08
Subject: Re: Query optimization help
Previous:From: Scott MarloweDate: 2011-08-30 06:39:43
Subject: Re: Re: How to track number of connections and hosts to Postgres cluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group