Rules: A Modest Proposal

From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Rules: A Modest Proposal
Date: 2009-10-04 17:54:13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


At the moment, user-accessible RULEs have, as far as I know, just two
sane uses:

* Writing to VIEWs
* Routing writes to partitions

And the second is pretty thin, given the performance issues for
numbers of partitions over 2.

What say we see about addressing those problems separately, and
removing user-accessible RULEs entirely?

There are already patches to deal with the first, at least for the
kinds of VIEWs where this can be deduced automatically, and people are
starting to take on the second.

The one remaining (as in nobody's really addressed it with code) issue
would be triggers on VIEWs. As other systems have done it, it's
clearly not essentially impossible. What would be needed?

David Fetter <david(at)fetter(dot)org>
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres:


Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2009-10-04 18:42:45 Re: Rules: A Modest Proposal
Previous Message Roger Leigh 2009-10-04 17:44:45 Re: Unicode UTF-8 table formatting for psql text output