Postgres Pro
Downloads
Home   >   mailing lists

should I increase default_statistics_target - Mailing list pgsql-general

From AI Rumman
Subject should I increase default_statistics_target
Date
Msg-id CAGoODpf=X9cLoECn8o0gH471zb=yJ8tbS8+hRDaZm8uVBf5fxA@mail.gmail.com
Whole thread Raw
Responses Re: should I increase default_statistics_target
List pgsql-general
Tree view
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? 

pgsql-general by date:

Previous
From: Arvind Singh
Date:
Subject: Re: application for postgres Log
Next
From: Ondrej Ivanič
Date:
Subject: Re: should I increase default_statistics_target