Re: default_statistics_target WAS: max_wal_senders must die - Mailing list pgsql-hackers

From Nathan Boley
Subject Re: default_statistics_target WAS: max_wal_senders must die
Date
Msg-id AANLkTinsGBjF=wh-N0XuujWB_es8VmAqgGMq=OwfxM7Y@mail.gmail.com
Whole thread Raw
In response to Re: default_statistics_target WAS: max_wal_senders must die  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
> That one's used, too, but the other is used as an upper bound.
> n_distinct tends to come out too small on large tables, so that
> formula is prone to overestimation.  Actually, both formulas are prone
> to overestimation.
>

Right - thanks.

> When this happens depends on the values of a whole boat-load of GUCs...

Well, then doesn't the 'proper' number of buckets depend on a whole
boat-load of GUCs...

-Nathan


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: lazy snapshots?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: default_statistics_target WAS: max_wal_senders must die