Re: [PATCHES] Avg performance for int8/numeric

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [PATCHES] Avg performance for int8/numeric
Дата
Msg-id 1164559292.3778.22.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: [PATCHES] Avg performance for int8/numeric  (Mark Kirkwood <markir@paradise.net.nz>)
Ответы Re: [PATCHES] Avg performance for int8/numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sat, 2006-11-25 at 18:57 +1300, Mark Kirkwood wrote:
> Also Neil suggested investigating using a single composite type
> {int8, 
> numeric} for the {N,sum(X)} transition values. This could well be a 
> faster way to do this (not sure how to make it work yet... but it
> sounds 
> promising...).

If that is true it implies that any fixed length array is more expensive
than using a composite type. Is there something to be gained by changing
the basic representation of arrays, rather than rewriting all uses of
them?

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




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

Предыдущее
От: "Jeroen T. Vermeulen"
Дата:
Сообщение: "Optional ident" authentication
Следующее
От: David Boreham
Дата:
Сообщение: Re: Integrating Replication into Core