Re: partitioned table query question - Mailing list pgsql-general

From Robert Treat
Subject Re: partitioned table query question
Date
Msg-id 200712110014.20720.robert@omniti.com
Whole thread Raw
In response to Re: partitioned table query question  (Erik Jones <erik@myemma.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Slow PITR restore
Next
From: Magicloud Wang
Date:
Subject: Would it be OK if I put db file on a ext2 filesystem?