Re: Improving avg performance for numeric

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Improving avg performance for numeric
Дата
Msg-id 525C6A5A.1000606@fuzzy.cz
обсуждение исходный текст
Ответ на Re: Improving avg performance for numeric  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On 24.9.2013 17:57, Pavel Stehule wrote:
> 
> 
> 
> 2013/9/24 Robert Haas <robertmhaas@gmail.com
> <mailto:robertmhaas@gmail.com>>
> 
> On Mon, Sep 23, 2013 at 4:15 PM, Tomas Vondra <tv@fuzzy.cz 
> <mailto:tv@fuzzy.cz>> wrote:
>> Seems "ready for commiter" to me. I'll wait a few days for others
>> to comment, and then I'll update the commitfest page.
> 
> Some thoughts:
> 
> The documentation doesn't reflect the restriction to type internal. 
> On a related note, why restrict this to type internal?
> 
> 
> 
> Now, for almost all types Postgres well estimate size of state
> value. Only arrays with unknown size can be a different. When we
> enable this value for all types, then users can specify some bad
> values for scalar buildin types. Next argument is simply and bad - I
> don't see a good use case for customization this value for other than
> types than internal type.
> 
> I have no strong position here - prefer joining with internal type
> due little bit higher robustness.

I share this oppinion. I was not able to come up with a single use case
benefiting from allowing this for types other than internal. Seems like
a footgun to me, with no potential benefit.

So +1 to keeping the patch 'type internal only' from me.

With the formatting issues now fixed, I believe the patch is ready for
committer (and someone already switched it to that state).

Tomas



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Re: [BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist
Следующее
От: Robert Haas
Дата:
Сообщение: Re: buildfarm failures on smew and anole