| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | Luis Silva <lfs12(at)hotmail(dot)com> |
| Cc: | Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: stress tests problems |
| Date: | 2006-04-24 20:12:39 |
| Message-ID: | 20060424201239.36771.qmail@web31801.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Chambers | 2006-04-24 20:45:44 | Re: stress tests problems |
| Previous Message | Luis Silva | 2006-04-24 17:02:17 | stress tests problems |