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
In response to
pgsql-performance by date
|Next:||From: Bricklen Anderson||Date: 2006-10-27 14:33:57|
|Subject: Re: query produces 1 GB temp file|
|Previous:||From: soni de||Date: 2006-10-27 13:12:35|
|Subject: Re: Regarding Bitmap Scan|