Skip site navigation (1) Skip section navigation (2)

Re: Searching for the cause of a bad plan

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Searching for the cause of a bad plan
Date: 2007-09-26 14:52:37
Message-ID: 1190818357.5430.29.camel@PCD12478 (view raw or flat)
Thread:
Lists: pgsql-performance
> 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: fresh_stats.txt
Description: text/plain (7.0 KB)

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2007-09-26 15:22:17
Subject: Re: Searching for the cause of a bad plan
Previous:From: Tom LaneDate: 2007-09-26 14:45:14
Subject: Re: Incorrect row estimates in plan?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group