Re: index vs. seq scan choice? - Mailing list pgsql-general

From Tom Lane
Subject Re: index vs. seq scan choice?
Date
Msg-id 115.1180063568@sss.pgh.pa.us
Whole thread Raw
In response to Re: index vs. seq scan choice?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: index vs. seq scan choice?
List pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane wrote:
>> I'm not sure I want to vote for another 10x increase by
>> default, though.

> Outside of longer analyze times, and slightly more space taken up by the
> statistics, what is the downside?

Longer plan times --- several of the selfuncs.c routines grovel over all
the entries in the pg_statistic row.  AFAIK no one's measured the real
impact of that, but it could easily be counterproductive for simple queries.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: index vs. seq scan choice?
Next
From: Steve Atkins
Date:
Subject: Re: index vs. seq scan choice?