Search Postgresql Archives
should I increase default_statistics_target
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: pgsql-general General <
pgsql-general@xxxxxxxxxxxxxx
>
Subject
: should I increase default_statistics_target
From
: AI Rumman <
rummandba@xxxxxxxxx
>
Date
: Thu, 20 Sep 2012 16:49:21 +0600
Using explain analyze of a large query I found that in every step there are a lot difference between the number of rows between actual and estimated.
I am using default_statistics_target 200. Should I increase it?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: should I increase default_statistics_target
From:
Ondrej Ivanič
Prev by Date:
Re: application for postgres Log
Next by Date:
Re: should I increase default_statistics_target
Previous by thread:
Getting a leading zero on negative intervals with to_char?
Next by thread:
Re: should I increase default_statistics_target
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
