Re: [PERFORM] [BUGS] Postgres user authentification or LDAP authentification

2009-07-26 Thread Alvaro Herrera
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 meto

Re: [PERFORM] Performance of quer or procedure going down when we are taking the backup

2009-07-26 Thread Robert Haas
On Mon, Jul 20, 2009 at 6:15 AM, ramasubramanian wrote: >   Dear all, >       Performance of query or procedure going down when we are taking the > backup of that schema(it is obvious), But how to  increase the performance. > > Regards, > Ram. You're going to need to provide an awful lot more deta

Re: [PERFORM] hyperthreaded cpu still an issue in 8.4?

2009-07-26 Thread Greg Smith
On Tue, 21 Jul 2009, Doug Hunley wrote: Just wondering is the issue referenced in http://archives.postgresql.org/pgsql-performance/2005-11/msg00415.php is still present in 8.4 or if some tunable (or other) made the use of hyperthreading a non-issue. We're looking to upgrade our servers soon for

Re: [PERFORM] Nested loop Query performance on PK

2009-07-26 Thread nha
Hello, Le 26/07/09 7:09, Greg Caulton a écrit : > On Sun, Jul 26, 2009 at 1:02 AM, Greg Caulton > wrote: > > Hello, > > It seems to me that the following query should be a lot faster. > This runs in 17 seconds (regardless how many times I run it) > >