> 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.