Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner selects different execution plans depending on limit - Mailing list pgsql-performance

From Tom Lane
Subject Re: Planner selects different execution plans depending on limit
Date
Msg-id 25753.1347545077@sss.pgh.pa.us
Whole thread Raw
In response to Re: Planner selects different execution plans depending on limit  (Bill Martin <bill.martin@communote.com>)
List pgsql-performance
Tree view 
Bill Martin <bill.martin@communote.com> writes:
> I�ve tried different values for the statistics but it is all the same (the planner decide to switch to a seqscan if
thelimit is 10). 

> ALTER TABLE core_content ALTER column content SET STATISTICS 1000;

Um, did you actually do an ANALYZE after changing that?

            regards, tom lane

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: : PostgreSQL Index behavior
Next
From: Bill Martin
Date:
Subject: Re: Planner selects different execution plans depending on limit