Skip site navigation (1) Skip section navigation (2)

Re: Postgres user authentification or LDAP authentification

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Lauris Ulmanis <lauris(dot)ulmanis(at)mykoob(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres user authentification or LDAP authentification
Date: 2009-07-27 02:00:19
Message-ID: 20090727020019.GC10327@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-performance
Lauris Ulmanis wrote:
> Hello!
> 
>  
> 
> I posted you a message about slowness of creation users more than 500 000
> (#4919). It seems there is no workaround of this problem because of using
> pg_auth flat file.
> 
>  
> 
> To override this problem is it possible to use LDAP authentification metod
> to identify each user and speed up system?

No.  The users still need to exist in the PG auth system.

I'm sure this is just some missing optimization.  Feel free to work on
the code to improve performance for these cases.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-performance by date

Next:From: DeveloperDate: 2009-07-27 09:06:41
Subject: More speed counting rows
Previous:From: Robert HaasDate: 2009-07-26 21:15:13
Subject: Re: Performance of quer or procedure going down when we are taking the backup

pgsql-bugs by date

Next:From: Itagaki TakahiroDate: 2009-07-27 02:11:19
Subject: Re: BUG #4941: pg_stat_statements crash
Previous:From: Wojciech WalczakDate: 2009-07-26 20:49:01
Subject: Postgresql, ts_headline() adds space when parsing url problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group