Re: Performance of full outer join in 8.3

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Christian Schröder <cs(at)deriva(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance of full outer join in 8.3
Date: 2009-04-15 11:43:04
Message-ID: 2f4958ff0904150443s595b54dfg2ccbdf973a99f051@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

set work_mem=24000; before running the query.

postgres is doing merge and sort on disc, that's always slow.

is there an index on column isin ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Schröder 2009-04-15 12:04:03 Re: Performance of full outer join in 8.3
Previous Message Quan Zongliang 2009-04-15 11:42:50 how to escape back-slash mark.

Browse pgsql-hackers by date

  From Date Subject
Next Message Sam Mason 2009-04-15 11:45:30 Re: Unicode string literals versus the world
Previous Message Christian Schröder 2009-04-15 11:03:53 Performance of full outer join in 8.3