Re: two dimensional statistics in Postgres

Поиск
Список
Период
Сортировка
От Gavin Flower
Тема Re: two dimensional statistics in Postgres
Дата
Msg-id 545B55FF.5080806@archidevsys.co.nz
обсуждение исходный текст
Ответ на Re: two dimensional statistics in Postgres  ("Tomas Vondra" <tv@fuzzy.cz>)
Ответы Re: two dimensional statistics in Postgres  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-hackers
On 06/11/14 23:57, Tomas Vondra wrote:
> Dne 6 Listopad 2014, 11:50, Gavin Flower napsal(a):
>> Could you store a 2 dimensional histogram in a one dimensional array:
>> A[z] = value, where z = col * rowSize + row (zero starting index)?
> How would that work for columns with different data types?
>
> Tomas
>
I implicitly assumed that all cells were the same size & type. However, 
I could devise a scheme to cope with columns of different types, given 
the relevant definitions - but this would obviously be more complicated.

Also this method can be extended into higher dimensions.


Cheers,
Gavin



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Typo in comment
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Order of views in stats docs