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

• 8.4 semi-join slows down query performance (EXISTS) at 2009-04-21 09:38:06 from vacuum

pgsql-hackers by date

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