Re: benchmarking the query planner - Mailing list pgsql-hackers

From Robert Haas
Subject Re: benchmarking the query planner
Date
Msg-id 603c8f070812120835x7a6b7588icdf6e876239a80d1@mail.gmail.com
Whole thread Raw
In response to Re: benchmarking the query planner  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: benchmarking the query planner  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: benchmarking the query planner  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: benchmarking the query planner  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-hackers
> Which raises the issue, if we could get better statistics by passing
> the whole table, why not do that when VACUUM ANALYZE is run?

I think the reason is "because the next autovacuum would undo it".

Perhaps a table-level option to scan the whole table instead of
estimating would be appropriate?
.
...Robert


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1268)
Next
From: Simon Riggs
Date:
Subject: Re: benchmarking the query planner