Re: 7.1 grant/revoke speed - Mailing list pgsql-sql

From Tom Lane
Subject Re: 7.1 grant/revoke speed
Date
Msg-id 4104.987177286@sss.pgh.pa.us
Whole thread Raw
In response to 7.1 grant/revoke speed  (Kyle <kyle@actarg.com>)
List pgsql-sql
Kyle <kyle@actarg.com> writes:
> Any reason why I should expect grants and/or revokes to be slower under
> 7.1RC3?

> I have a script that grants all our privileges and it takes about 5 to
> 10 times longer to run than it did under 7.0.3.

Seems unlikely that the problem is with the grants/revokes per se;
probably the slowdown is elsewhere.  Have you looked for changes in
the EXPLAIN results for the queries being used?
        regards, tom lane


pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Debian Package problems
Next
From: Roberto Mello
Date:
Subject: Re: Debian Package problems