[PERFORM] Postgres user authentification or LDAP authentification

2009-07-23 Thread Lauris Ulmanis
pooling without using postgres users? __ Lauris Ulmanis Tel. +371 29471020

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down systemperformance

2009-07-16 Thread Lauris Ulmanis
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

Re: [PERFORM] [BUGS] BUG #4919: CREATE USER command slows down system performance

2009-07-16 Thread Lauris Ulmanis
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

[PERFORM] CREATE USER command slows down when user count per server reaches up to 500 000

2009-07-14 Thread Lauris Ulmanis
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