On 20 March 2012 21:54, Brent Wood <Brent.Wood@xxxxxxxxxx> wrote: > > Also look at a clustered index on timestamp Thanks, this looks very helpful. what do you think about the thousands table vs one table partitioned by month? I guess if I go with one table, index would be too big to fit in ram? Jim. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general