Re: Slow Performance

* Gavin M. Roy <gmr@readysetnet.com> [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 like when running simple sql queries on one and
> two tables.  When I look at postgres I notice it's only using 80 megs.
>
> 1) Would increasing the memory postgresql is using increase performance?
>
> Here's my current command line:
> /usr/local/pgsql/bin/postmaster -S -D /usr/local/pgsql/data -i -o '-F'
> -B 2048 -N 1024 &

Yes, try running a shared memorry segment of at least 256 megs.

> 2) Are there any other suggestions to how I run Postgresql to increase
> my performance issues?

Make sure you periodically do a 'vacuum analyze' on the tables and
make sure you have proper indexing.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."