Re: optimizing large query with IN (...)

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Eric Jain <Eric(dot)Jain(at)isb-sib(dot)ch>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: optimizing large query with IN (...)
Date: 2004-03-10 08:38:39
Message-ID: 404ED40F.2040800@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>UPDATE table SET table.par = table.par + 1
>>WHERE table.key IN ('value1', 'value2', ... , 'value1200' )
>
>
> How fast is the query alone, i.e.
>
> SELECT * FROM table
> WHERE table.key IN ('value1', 'value2', ... , 'value1200' )

Also, post the output of '\d table' and EXPLAIN ANALYZE UPDATE...

Chris

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shea,Dan [CIS] 2004-03-10 13:56:57 Cluster failure due to space
Previous Message Eric Jain 2004-03-10 08:13:37 Re: optimizing large query with IN (...)