[PERFORM] Looking for installations with a large number of concurrent users

2009-06-09 Thread David Kerr
Hello all, We're implementing a fairly large J2EE application, I'm estimating around 450,000 concurrent users at high peak. Performing reads and writes and we have a very high performance requirement. I'll be using connection pooling (probably the pooling delivered with Geronimo). I'd like to

Re: [PERFORM] Problems with autovacuum

2009-06-09 Thread Tom Lane
Alvaro Herrera writes: > Glitches fixed in this version; will apply shortly to 8.3 and HEAD. Looks sane; one trivial grammar correction: > + /* the minimum allowed time between two awakening of the launcher */ Should read "two awakenings". regards, tom lane -- Sent vi

Re: [PERFORM] Problems with autovacuum

2009-06-09 Thread Alvaro Herrera
Alvaro Herrera escribió: > Tom Lane escribió: > > > Well, that code isn't even correct I think; you're not supposed to > > modify a GUC variable directly. I think you should just silently > > use a naptime of at least X without changing the nominal GUC variable. > > And definitely without the WAR

Re: [PERFORM] Problems with autovacuum

2009-06-09 Thread Alvaro Herrera
Tom Lane escribió: > Well, that code isn't even correct I think; you're not supposed to > modify a GUC variable directly. I think you should just silently > use a naptime of at least X without changing the nominal GUC variable. > And definitely without the WARNING --- that's nothing but log spam.

Re: [PERFORM] Best way to load test a postgresql server

2009-06-09 Thread Tom Lane
Shaul Dar writes: > Have you actually run pgbench against your own schema? Can you point me to > an example? I also had the same impression reading the documentation. But > when I tried it with the proper flags to use my own DB and query file I got > an error that it couldn't find one of the table

Re: [PERFORM] Best way to load test a postgresql server

2009-06-09 Thread Shaul Dar
On Thu, Jun 4, 2009 at 2:01 AM, Greg Smith wrote: > > If you want to load test your own specific DB then I am unaware of any >> such tools. >> > > pgbench will run against any schema and queries, the built-in set are just > the easiest to use. I just released a bunch of slides and a package I n

Re: [PERFORM] Pointers needed on optimizing slow SQL statements

2009-06-09 Thread Dimitri Fontaine
Віталій Тимчишин writes: > I'd prefer ALTER VIEW SET ANALYZE=true; or CREATE/DROP ANALYZE ; > Also it should be possible to change statistics target for analyzed > columns. Yeah, my idea was ALTER VIEW ENABLE ANALYZE; but that's an easy point to solve if the idea proves helpful. > Such a stat