Re: PostgreSQL underestimates sorting

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL underestimates sorting
Date: 2006-11-22 13:54:34
Message-ID: 20061122135434.GA9669@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Nov 22, 2006 at 11:17:23AM +0100, Markus Schaber wrote:
> The Backend allocates gigs of memory (we've set sort_mem to 1 gig), and
> then starts spilling out more Gigs of temporary data to the disk.

How much RAM is in the server? Remember that sort_mem is _per sort_, so if
you have multiple sorts, it might allocate several multiples of the amount
you set up.

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bucky Jordan 2006-11-22 14:18:11 Re: availability of SATA vendors
Previous Message Markus Schaber 2006-11-22 10:17:23 PostgreSQL underestimates sorting