Re: Large IN query optimization

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Worky Workerson" <worky(dot)workerson(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large IN query optimization
Date: 2006-12-13 19:08:44
Message-ID: 10504.1166036924@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Worky Workerson" <worky(dot)workerson(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-12-13 19:09:02 Re: MySQL drops support for most distributions
Previous Message Markus Schiltknecht 2006-12-13 19:06:49 Re: MySQL drops support for most distributions