Re: partitioned table query question

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: partitioned table query question
Дата
Msg-id 200712110014.20720.robert@omniti.com
обсуждение исходный текст
Ответ на Re: partitioned table query question  (Erik Jones <erik@myemma.com>)
Список pgsql-general
On Monday 10 December 2007 20:01, Erik Jones wrote:
> Again, though, is there some better way to go about implementing some
> kind of hash based partitioning in postgres besides this that would
> be more natural wrt queries?
>

One way is to set a static bin id for each partition, then do a select with
where bin_id = mod(2112,3);   Where 2112 equals the number your looking for,
and 3 would be the number of buckets.

--
Robert Treat
http://www.omniti.com/
We're Big. On PostgreSQL.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Slow PITR restore
Следующее
От: Magicloud Wang
Дата:
Сообщение: Would it be OK if I put db file on a ext2 filesystem?