Re: 8.4 semi-join slows down query performance (EXISTS) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: 8.4 semi-join slows down query performance (EXISTS)
Date
Msg-id 20090421135811.GM10358@alvh.no-ip.org
Whole thread Raw
In response to 8.4 semi-join slows down query performance (EXISTS)  (vacuum@quantentunnel.de)
List pgsql-hackers
vacuum@quantentunnel.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.


pgsql-hackers by date:

Previous
From: "Dickson S. Guedes"
Date:
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax
Next
From: Kedar Potdar
Date:
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax