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

From Bill Martin
Subject Re: Planner selects different execution plans depending on limit
Date
Msg-id D48BF41C96B16442B542F5E25C259047011E80F02A@COM211.communardo.local
Whole thread Raw
Responses Re: Planner selects different execution plans depending on limit
List pgsql-performance
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> 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

Yes, I've run the ANALYZE command.

Regards,
Bill Martin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner selects different execution plans depending on limit
Next
From: Jesper Krogh
Date:
Subject: Re: Planner selects different execution plans depending on limit