Josh Berkus wrote:
 - 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?

Just that I'd love to see it happen ;-)

Maybe someday I'll be able to find the time to work on it myself, but for the moment I'm satisfied with the workarounds we've made.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to