Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-24 Thread Todd Landfried
For those who provided some guidance, I say "thank you." You comments helped out a lot. All of our customers who are using the older release are now very pleased with the performance of the database now that we were able to give them meaningful configuration settings. I'm also pleased to se

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-16 Thread Bruno Wolff III
On Thu, Jun 16, 2005 at 07:46:45 -0700, Todd Landfried <[EMAIL PROTECTED]> wrote: > Yes, it is 7.2. Why? because an older version of our software runs on > RH7.3 and that was the latest supported release of Postgresql for > RH7.3 (that we can find). We're currently ported to 8, but we still

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-16 Thread Todd Landfried
Yes, it is 7.2. Why? because an older version of our software runs on RH7.3 and that was the latest supported release of Postgresql for RH7.3 (that we can find). We're currently ported to 8, but we still have a large installed base with the other version. On Jun 15, 2005, at 7:18 AM, Tom L

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-15 Thread Josh Berkus
Dennis, > http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > > > NOTICE: shared_buffers is 256 For everyone's info, the current (8.0) version is at: http://www.powerpostgresql.com/PerfList -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(en

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-15 Thread Tom Lane
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > On Wed, 15 Jun 2005, Todd Landfried wrote: >> NOTICE: shared_buffers is 256 > This looks like it's way too low. Try something like 2048. It also is evidently PG 7.2 or before; SHOW's output hasn't looked like that in years. Try a more recent releas

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-15 Thread Bruno Wolff III
On Wed, Jun 15, 2005 at 02:06:27 -0700, Todd Landfried <[EMAIL PROTECTED]> wrote: > > What's the problem? The sucker gets s-l-o-w on relatively simple > queries. For example, simply listing all of the users online at one > time takes 30-45 seconds if we're talking about 800 users. We've >

Re: [PERFORM] Needed: Simplified guide to optimal memory configuration

2005-06-15 Thread Dennis Bjorklund
On Wed, 15 Jun 2005, Todd Landfried wrote: > So, what I need is to be pointed to (or told) what are the best > settings for our database given these memory configurations. What > should we do? Maybe this will help: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > NOTICE: sha