On 2/5/05, Dirk Lutzebaeck <lutzeb@xxxxxxxxxx> 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
