pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
7.1 grant/revoke speed 2+ messages / 2 participants [nested] [flat]
* 7.1 grant/revoke speed @ 2001-04-07 20:22 Kyle <kyle@actarg.com> 0 siblings, 1 reply; 2+ messages in thread From: Kyle @ 2001-04-07 20:22 UTC (permalink / raw) To: pgsql-sql 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. Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadkyle.vcf (text/x-vcard, 184B) download
begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:kyle@actarg.com title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard
* Re: 7.1 grant/revoke speed @ 2001-04-13 15:54 Tom Lane <tgl@sss.pgh.pa.us> parent: Kyle <kyle@actarg.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2001-04-13 15:54 UTC (permalink / raw) To: Kyle <kyle@actarg.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-13 15:54 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-04-07 20:22 7.1 grant/revoke speed Kyle <kyle@actarg.com> 2001-04-13 15:54 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox