Scara Maccai <m_lists@xxxxxxxx> wrote: > - create table mytable as select * from <parent_table> where time > <in last month> (this gets all the data of last month ordered in the > "almost" correct order, because all the single tables were > clustered) Be sure to include an ORDER BY clause. Without that, there is no guarantee that even two successive SELECTs from the same table, with no modifications between, will return rows in the same order. For example, if someone else starts a query which the planner determines is best handled with a table scan, and that is still running when you issue your INSERT/SELECT, your query will join the current scan at it's point of progress, and "wrap around" when it hits the end. Also, there would be no guarantee of what order the child tables were read. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
