Postgres Pro
Downloads
Home   >   mailing lists

Re: Large IN query optimization - Mailing list pgsql-general

From Tom Lane
Subject Re: Large IN query optimization
Date
Msg-id 10504.1166036924@sss.pgh.pa.us
Whole thread Raw
In response to Large IN query optimization  ("Worky Workerson" <worky.workerson@gmail.com>)
Responses Re: Large IN query optimization  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
"Worky Workerson" <worky.workerson@gmail.com> writes:
> I'm wondering (given what I have read about PG and IN), if there is a
> better way to execute this query.
> ... (as I have partitioned the events table by ip):

Are you on 8.2?  8.1 is pretty stupid about joins to inheritance trees.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: MySQL drops support for most distributions
Next
From: Tom Lane
Date:
Subject: Re: plperl exception catching