Re: Patch for information_schema performance

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Joachim Wieland <joe(at)mcknight(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org, xi(at)gamma(dot)dn(dot)ua
Subject: Re: Patch for information_schema performance
Date: 2009-12-05 21:44:18
Message-ID: 1260049458.20505.1.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On fre, 2009-09-25 at 00:55 +0200, Joachim Wieland wrote:
> the attached patch addresses the performance issues of the
> authorization related views from information_schema (BUG #4596). It
> implements what Tom suggests in
>
> http://archives.postgresql.org/pgsql-bugs/2008-12/msg00144.php
>
> In the cases that I have tested both the new and the old view return
> the same data but I'd appreciate more tests. The patch currently does
> not remove the original views but renames them from xyz to old_xyz, so
> you can run your own tests of the new view definition vs. the old one.

Committed with a bunch of cleanup.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2009-12-06 00:46:29 Re: YAML Was: CommitFest status/management
Previous Message David Fetter 2009-12-05 21:24:38 Re: operator exclusion constraints