Re: PG9.0 planner difference to 8.3 -> majorly bad performance

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Uwe Schroeder <uwe(at)oss4u(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Thom Brown <thom(at)linux(dot)com>
Subject: Re: PG9.0 planner difference to 8.3 -> majorly bad performance
Date: 2011-01-29 19:05:23
Message-ID: 20110129190523.GQ30352@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Uwe Schroeder (uwe(at)oss4u(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Warner 2011-01-29 21:00:49 Re: Full Text Index Scanning
Previous Message Uwe Schroeder 2011-01-29 18:24:28 Re: PG9.0 planner difference to 8.3 -> majorly bad performance