Postgres Pro
Downloads
Home   >   mailing lists

Re: Searching for the cause of a bad plan - Mailing list pgsql-performance

From Csaba Nagy
Subject Re: Searching for the cause of a bad plan
Date
Msg-id 1190818357.5430.29.camel@PCD12478
Whole thread Raw
In response to Re: Searching for the cause of a bad plan  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Searching for the cause of a bad plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> Csaba, please can you copy that data into fresh tables, re-ANALYZE and
> then re-post the EXPLAINs, with stats data.

Here you go, fresh experiment attached.

Cheers,
Csaba.
Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Incorrect row estimates in plan?
Next
From: Tom Lane
Date:
Subject: Re: Searching for the cause of a bad plan