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

Re: Odd behavior with temp usage logging

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Odd behavior with temp usage logging
Date: 2009-01-27 08:14:06
Message-ID: 497EC24E.5040805@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
Josh Berkus wrote:
> Folks,
> 
> I turned on temp file logging for PostgreSQL to see if I needed to
> adjust work_mem.  Oddly, it's logging file usage up to 33 times per
> executed query (and no, the query isn't large enough to need 33 separate
> sorts).

Are you sure there's not a sort happening inside a loop? It might help
if you posted the actual log messages along with the output of `EXPLAIN
ANALYZE' on your query.

--
Craig Ringer

In response to

Responses

pgsql-performance by date

Next:From: A BDate: 2009-01-27 08:20:10
Subject: Re: [PERFORMANCE] Buying hardware
Previous:From: davidDate: 2009-01-27 07:51:33
Subject: Re: SSD performance

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