On Tue, Sep 28, 2010 at 12:37 AM, Tim Uckun <timuckun@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
