On Tue, Jan 29, 2008 at 03:01:27AM -0500, Oren Laadan wrote: > Hi, > > After switching to LDAP authentication on our system, I noticed that > PostgreSQL start-up (and shut-down) time because ridiculously high. > (The PostgreSQL server isn't used as the back-end for LDAP; the LDAP > servers sits elsewhere). > > Searching through google yielded the following post which seems still > unresolved: > http://www.mail-archive.com/[email protected]/msg483707.html > > By looking at the LDAP server logs, I noticed that during the long time > it takes the PostgreSQL server to start, it continuously queries the > LDAP server (there are many hundreds of users and groups in our domain). > > Looking back at the start-up code, I narrowed the program down to the > /usr/share/postgresql-common/PgCommon.pm file, and more specifically > the function "change_ugid()": this functions loops through the entire > LDAP database, entry by entry, repeatedly querying the LDAP server and > consuming cpu, network and most of all lost of time ... > > This seems like a bug (inefficient implementation) in PostgreSQL. > (it doesn't look like a problem in the way the LDAP client side - or > server - have been setup). > > This problem is verified for postgresql-client-common versions 8.1, > and 8.3 on debian unstable, and testing. > > I'd appreciate suggestions as how this can be solved. have you tried using nscd ?
>
> Thanks,
>
> Oren.
>
> (ps. please CC me as I'm not subscribed to the list)
>
>
> --
> To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a
> subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
>
>
--
"And so, in my State of the -- my State of the Union -- or state -- my speech
to the nation, whatever you want to call it, speech to the nation -- I asked
Americans to give 4,000 years -- 4,000 hours over the next -- the rest of your
life -- of service to America."
- George W. Bush
04/09/2002
Bridgeport, Conn.
signature.asc
Description: Digital signature
