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

Re: query produces 1 GB temp file

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Dirk Lutzebaeck" <lutzeb(at)aeccom(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: query produces 1 GB temp file
Date: 2006-10-27 13:49:34
Message-ID: b42b73150610270649q4ee58b8as6aa03433b562e5e5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 2/5/05, Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com> wrote:
> here is a query which produces over 1G temp file in pgsql_tmp. This
> is on pgsql 7.4.2, RHEL 3.0, XEON MP machine with 32GB RAM, 300MB
> sort_mem and 320MB shared_mem.
>
> Below is the query and results for EXPLAIN and EXPLAIN ANALYZE. All
> tables have been analyzed before.
>
> Can some please explain why the temp file is so huge? I understand
> there are a lot of rows. All relevant indices seem to be used.

how much memory have you set aside for sorting? also, this query will
likely run better in a more recent version of postgresql if thats
possible.

merlin

In response to

Responses

pgsql-performance by date

Next:From: Bricklen AndersonDate: 2006-10-27 14:33:57
Subject: Re: query produces 1 GB temp file
Previous:From: soni deDate: 2006-10-27 13:12:35
Subject: Re: Regarding Bitmap Scan

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