Re: 8.4 semi-join slows down query performance (EXISTS)

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: vacuum(at)quantentunnel(dot)de
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.4 semi-join slows down query performance (EXISTS)
Date: 2009-04-21 13:58:11
Message-ID: 20090421135811.GM10358@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

vacuum(at)quantentunnel(dot)de wrote:
> Hello folk,
>
> I migrate a pg 8.3 database to a pg 8.4 backend for testing. All works
> fine except changes or new features of the planner.
>
> There are two tables. The first (A) stores "data" - second table (B)
> holds (forinstance) "structure" information and references to A by
> defining foreign-key constraint(s).

Can you please post the table definitions? "pg_dump -t" output would be
best.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikko 2009-04-21 13:58:21 Re: trouble with to_char('L')
Previous Message Dickson S. Guedes 2009-04-21 13:46:41 Re: Automating Partitions in PostgreSQL - Query on syntax