pooling without using postgres users?
__
Lauris Ulmanis
Tel. +371 29471020
all users.
-Original Message-
From: Alvaro Herrera [mailto:alvhe...@commandprompt.com]
Sent: Wednesday, July 15, 2009 5:02 PM
To: Lauris Ulmanis
Cc: 'Heikki Linnakangas'; pgsql-b...@postgresql.org;
pgsql-performance@postgresql.org
Subject: Re: [BUGS] BUG #4919: CREATE USE
reason of this slowness? Is there a workaround or solution how to
avoid it?
-Original Message-
From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com]
Sent: Tuesday, July 14, 2009 6:09 PM
To: Lauris Ulmanis
Cc: pgsql-b...@postgresql.org
Subject: Re: [BUGS] BUG #4919: CREATE
When users count in Postgres database reaches up to 500 000 - database
command of creating users 'CREATE USER' slows down to 5-10 seconds per user.
What could be a reason of this problem and is there any solution how to
avoid it?
For each of user can be associated up to 10 roles with grants to sy