Re: [SQL] Some quick questions

2010-08-04 Thread Kenneth Marshall
On Wed, Aug 04, 2010 at 10:22:12AM -0400, Joshua Gooding wrote: > I am using Postgres 8.4 with 10 partition tables. We'll call them > reports_00 through reports_09. > > I have a field that is a BIGINT which is a 13 digit number that is the > epoch time, which is the constraint that the table is

[SQL] Some quick questions

2010-08-04 Thread Joshua Gooding
I am using Postgres 8.4 with 10 partition tables. We'll call them reports_00 through reports_09. I have a field that is a BIGINT which is a 13 digit number that is the epoch time, which is the constraint that the table is partitioned on. (Between time x and y). All of the partitions hold 10