Re: join question

From: "marcin mank" <marcin(dot)mank(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: "Postgres General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: join question
Date: 2008-10-22 23:41:44
Message-ID: b1b9fac60810221641v58153033h9173f8333001b7ee@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Sort Method: external sort Disk: 1320kB

One simple speedup could be upping Your work_mem to 2M for this query,
so the sorts are in memory.

btw: Last time I used Postgres, it did not show the sort method. Cool.

Greetings
Marcin Mank

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-10-22 23:53:20 Re: join question
Previous Message Grzegorz Jaśkiewicz 2008-10-22 23:29:34 Re: join question