On Tue, Sep 28, 2010 at 12:37 AM, Tim Uckun <timuckun@gmail.com> wrote:
>> If the table is large, I sometimes use the following pattern:
>
> The table is very large so I will use your advice thanks.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
The other thing that just hit my mind, is that you mind need to bump
up work_mem a bit, just for the session. so
SET work_mem=32M
<your query>
and that should make it slightly faster.
--
GJ