Re: 7.1 grant/revoke speed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kyle <kyle(at)actarg(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: 7.1 grant/revoke speed
Date: 2001-04-13 15:54:46
Message-ID: 4104.987177286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kyle <kyle(at)actarg(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-04-13 16:08:03 BOOLEAN data type?
Previous Message Roberto Mello 2001-04-13 15:50:53 Re: Debian Package problems