On Tue, Jun 21, 2011 at 01:07:17PM -0400, Robert Haas wrote: > On Mon, Jun 20, 2011 at 5:42 PM, David Fetter <da...@fetter.org> wrote: > > I noticed that we have some nice new speed optimizations (more > > properly, de-pessimizations) for partitioned tables in 9.1. > > /me sticks tongue out at dfetter. > > > Anybody care to look over the table partitioning stuff on the wiki and > > check it for relevance? > > > > http://wiki.postgresql.org/wiki/Table_partitioning > > Itagaki Takahiro had a patch for this about a year ago, but I wasn't > happy with the system catalog representation he chose and I think > there were some other issues as well.
In particular, I'm noticing things labeled 8.4 and 9.0 as future. > Still, I think a pretty clear > way forward here is to try to figure out a way to add some explicit > syntax for range partitions, so that you can say... > > foo_a is for all rows where foo starts with 'a' > foo_b is for all rows where foo starts with 'b' > ... > foo_xyz is for all rows where foo starts with 'xyz' > > If we have that data represented explicitly in the system catalog, > then we can look at doing built-in INSERT-routing and UPDATE-handling. > For an added bonus, it's a more natural syntax. Does someone else have such a syntax? Does The Standard™ have anything to say? Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
