Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3DFsw860771 for ; Fri, 13 Apr 2001 11:54:58 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f3DFskR04107; Fri, 13 Apr 2001 11:54:46 -0400 (EDT) To: Kyle cc: pgsql-sql@postgresql.org Subject: Re: 7.1 grant/revoke speed In-reply-to: <3ACF770F.D5E65105@actarg.com> References: <3ACF770F.D5E65105@actarg.com> Comments: In-reply-to Kyle message dated "Sat, 07 Apr 2001 14:22:39 -0600" Date: Fri, 13 Apr 2001 11:54:46 -0400 Message-ID: <4104.987177286@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/200 X-Sequence-Number: 2550 Kyle 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