Re: [ADMIN] Slow Performance

2000-10-24 Thread Gavin M. Roy
Thanks, I am now running -B 32768 and Postgres is nicely occupying 800+ megs of memory. We're doing testing now to see how it effects performance. Alfred Perlstein wrote: > * Gavin M. Roy <[EMAIL PROTECTED]> [001024 13:12] wrote: > > Am looking here: > > http://www.postgresql.org/devel-corner/d

Re: [ADMIN] Slow Performance

2000-10-24 Thread Alfred Perlstein
* Gavin M. Roy <[EMAIL PROTECTED]> [001024 11:09] wrote: > I have a monster db server, with 2 gigs of memory all for PostgresQL > 7.0.2. The machine is a PIII - 800 Zeon with 10,000 RPM SCSI drives. I > have a database with about 8 tables with over 1.5 Million rows. It's > running slower than I

Re: [ADMIN] Slow Performance

2000-10-24 Thread Gavin M. Roy
Am looking here: http://www.postgresql.org/devel-corner/docs/admin/runtime-config.htm but not seeing anything on shared memory. Do you know the configuration option for this? Gavin Alfred Perlstein wrote: > * Gavin M. Roy <[EMAIL PROTECTED]> [001024 11:09] wrote: > > I have a monster db serve

Re: [ADMIN] Slow Performance

2000-10-24 Thread Alfred Perlstein
* Gavin M. Roy <[EMAIL PROTECTED]> [001024 13:12] wrote: > Am looking here: > http://www.postgresql.org/devel-corner/docs/admin/runtime-config.htm > > but not seeing anything on shared memory. Do you know the configuration > option for this? -B > > Gavin > > Alfred Perlstein wrote: > > >