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

Re: Query performance

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: S Arvind <arvindwill(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2009-10-12 13:29:13
Message-ID: 2f4958ff0910120629n7390ad4cuc279eee3367ee1d7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
btw, what's the version of db ?
what's the work_mem setting ?

try setting work_mem to higher value. As postgresql will fallback to disc
sorting if the content doesn't fit in work_mem, which it probably doesn't
(8.4+ show the memory usage for sorting, which your explain doesn't have).

In response to

Responses

pgsql-performance by date

Next:From: Matthew WakelingDate: 2009-10-12 13:36:59
Subject: Re: Query performance
Previous:From: S ArvindDate: 2009-10-12 13:23:22
Subject: Re: Query performance

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