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: (view raw or whole 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


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-2015 The PostgreSQL Global Development Group