Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad execution plan when joining partitioned tables - Mailing list pgsql-sql

From Richard Schmidlechner
Subject Re: Bad execution plan when joining partitioned tables
Date
Msg-id 1439ce7f-5053-4a61-8237-df7c301e8518@elisanet.fi
Whole thread Raw
In response to Bad execution plan when joining partitioned tables  (Richard Schmidlechner <richard.schmidlechner@elisanet.fi>)
Responses RE: Bad execution plan when joining partitioned tables  ("Jean-Marc Voillequin (MA)" <Jean-Marc.Voillequin@moodys.com>)
List pgsql-sql
Tree view 
Hi,

After updating db statistics the number of estimated rows has been correct

VACUUM ANALYZE a;
VACUUM ANALYZE b;

pgsql-sql by date:

Previous
From: Richard Schmidlechner
Date:
Subject: Bad execution plan when joining partitioned tables
Next
From: "Jean-Marc Voillequin (MA)"
Date:
Subject: RE: Bad execution plan when joining partitioned tables