Home > mailing lists

Re: Performance of full outer join in 8.3 - Mailing list pgsql-general

From	Grzegorz Jaśkiewicz
Subject	Re: Performance of full outer join in 8.3
Date	April 15, 2009 11:43:13
Msg-id	2f4958ff0904150443s595b54dfg2ccbdf973a99f051@mail.gmail.com Whole thread Raw
In response to	Performance of full outer join in 8.3 (Christian Schröder <cs@deriva.de>)
Responses	Re: Performance of full outer join in 8.3
List	pgsql-general

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 ?

From: Quan Zongliang
Date: 15 April 2009, 11:43:05
Subject: how to escape back-slash mark.

From: Christian Schröder
Date: 15 April 2009, 12:04:20
Subject: Re: Performance of full outer join in 8.3