From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | "Gavin M(dot) Roy" <gmr(at)readysetnet(dot)com> |
Cc: | pgsql list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Slow Performance |
Date: | 2000-10-24 18:31:41 |
Message-ID: | 20001024113140.F28123@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
* Gavin M. Roy <gmr(at)readysetnet(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin M. Roy | 2000-10-24 20:11:40 | Re: Slow Performance |
Previous Message | Gavin M. Roy | 2000-10-24 17:25:26 | Slow Performance |