Postgres Pro
Downloads
Home   >   mailing lists

Re: join question - Mailing list pgsql-general

From marcin mank
Subject Re: join question
Date
Msg-id b1b9fac60810221641v58153033h9173f8333001b7ee@mail.gmail.com
Whole thread Raw
In response to Re: join question  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view 
>    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

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: join question
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: join question