| Lists: | pgsql-hackers |
|---|
| From: | Joachim Wieland <joe(at)mcknight(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | xi(at)gamma(dot)dn(dot)ua |
| Subject: | Patch for information_schema performance |
| Date: | 2009-09-24 22:55:14 |
| Message-ID: | dc7b844e0909241555p6c2ef2b9x1cc9d8356d74cebe@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi,
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.
I also include a psql file that might help you testing.
Regards,
Joachim
| Attachment | Content-Type | Size |
|---|---|---|
| aclexplode.diff | text/x-diff | 24.2 KB |
| compare.psql | application/octet-stream | 2.9 KB |
| 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 |
| 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.