Joe, > - the use of inherited tables to partition this huge number of rows and > yet allow simple query access to it seems to work well, at least in > early validation tests > - had we simply taken the original database and "slammed" it into > Postgres with no further thought, we would not have seen the big > improvements, and thus the project might have been seen as a failure > (even though it saves substantial $)
Any further thoughts on developing this into true table partitioning? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly