Postgres Pro
Downloads
Home   >   mailing lists

Re: optimizing large query with IN (...) - Mailing list pgsql-performance

From Eric Jain
Subject Re: optimizing large query with IN (...)
Date
Msg-id 001401c40677$9723fed0$c300000a@caliente
Whole thread Raw
In response to optimizing large query with IN (...)  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Responses Re: optimizing large query with IN (...)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
Tree view 
> 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' )

pgsql-performance by date:

Previous
From: "Marcus Andree S. Magalhaes"
Date:
Subject: optimizing large query with IN (...)
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: optimizing large query with IN (...)