Postgres Pro
Downloads
Home   >   mailing lists

Re: PG9.0 planner difference to 8.3 -> majorly bad performance - Mailing list pgsql-general

From Stephen Frost
Subject Re: PG9.0 planner difference to 8.3 -> majorly bad performance
Date
Msg-id 20110129190523.GQ30352@tamriel.snowman.net
Whole thread Raw
In response to Re: PG9.0 planner difference to 8.3 -> majorly bad performance  (Uwe Schroeder <uwe@oss4u.com>)
List pgsql-general
Tree view 
* Uwe Schroeder (uwe@oss4u.com) wrote:
> Yes, the database is vacuumed and analyzed. The bad plan from 9.0 improves by
> 2 seconds when I go for a really high statistics target of 5000.

What if you go back to 10..?

    Stephen
Attachment

pgsql-general by date:

Previous
From: Uwe Schroeder
Date:
Subject: Re: PG9.0 planner difference to 8.3 -> majorly bad performance
Next
From: Matt Warner
Date:
Subject: Re: Full Text Index Scanning