Quick Links

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

From:	"Eric Jain" <Eric(dot)Jain(at)isb-sib(dot)ch>
To:	"pgsql-performance" <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: optimizing large query with IN (...)
Date:	2004-03-10 08:13:37
Message-ID:	001401c40677$9723fed0$c300000a@caliente
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' )

In response to

optimizing large query with IN (...) at 2004-03-10 03:35:15 from Marcus Andree S. Magalhaes

Responses

Re: optimizing large query with IN (...) at 2004-03-10 08:38:39 from Christopher Kings-Lynne

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Christopher Kings-Lynne	2004-03-10 08:38:39	Re: optimizing large query with IN (...)
Previous Message	Maneesha Nunes	2004-03-10 07:03:01	Drop Tables Very Slow in Postgresql 7.2.1