pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ben Young <Ben.Young@etrials.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow Restoration of a template1 Database (ALTER GROUP)
Date: Tue, 08 Feb 2005 13:57:40 -0500
Message-ID: <9190.1107889060@sss.pgh.pa.us> (raw)
In-Reply-To: <41A1CBC76FDECC42B67946519C6677A901D301FB@pippin.int.etrials.com>
References: <41A1CBC76FDECC42B67946519C6677A901D301FB@pippin.int.etrials.com>

"Ben Young" <Ben.Young@etrials.com> writes:
> When trying to restore my template1 database (7.3.4) I am 
> experiencing very long delays.  For 600 users (pg_shadow) 
> and 4 groups (pg_group) it is taking 1hr and 17 minutes to 
> complete.  All of the create user statements are processed in a 
> matter of seconds, but each alter groups statement takes 
> about 10 seconds to process.

I tried doing 1000 ALTER GROUP ADD USER commands in 7.3, and didn't
see any particular performance problem.  Could we see the output
of "VACUUM FULL VERBOSE pg_group"?

			regards, tom lane



view thread (5+ messages)  latest in thread

Message-ID: <9190.1107889060@sss.pgh.pa.us>
Permalink:  ../9190.1107889060@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/9190.1107889060@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Ben.Young@etrials.com
  Subject: Re: Slow Restoration of a template1 Database (ALTER GROUP)
  In-Reply-To: <9190.1107889060@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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