Re: stress tests problems - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: stress tests problems
Date
Msg-id 20060424201239.36771.qmail@web31801.mail.mud.yahoo.com
Whole thread Raw
In response to stress tests problems  ("Luis Silva" <lfs12@hotmail.com>)
List pgsql-novice
> HI there! I'm doing some stress test in my db with 100.000 users (rows) in
> one of my tables. I'm using indexes,vacuum, and other stuff but the db is
> too slow. Is there any other mechanism to optimize the db? tks in advance

This link should be a good resource for improving database preformance.
http://www.postgresql.org/docs/8.1/interactive/maintenance.html

Additional steps would be to "tune" your PostgreSQL configuration.
http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.html

There are additional links that describe what to do with these setting if you are interested.


Lastly,  you could always upgrade your hardware. :-)

Regards,

Richard Broersma Jr.

pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: stress tests problems
Next
From: Andrew Chambers
Date:
Subject: Re: stress tests problems