Have run "explain" on your queries to check whether your indexes are
being used. You could also check out the stats view as well to get an
overall picture of what's going on during the test as far as sequential
versus index scans, buffer reads versus disks reads,etc. Check out for
example, pg_stat_all_tables, pg_stat_io_tables, etc..
http://www.postgresql.org/docs/8.1/interactive/monitoring-stats.html
----
Husam
http://firstdba.googlepages.com/
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Luis Silva
Sent: Monday, April 24, 2006 10:02 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] stress tests problems
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may
containinformation that is legally privileged. If you are not the addressee, or the person responsible for delivering
itto the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is
strictlyprohibited. If you have received this message by mistake, please immediately notify us by replying to the
messageand delete the original message immediately thereafter.
Thank you.
FADLD Tag
**********************************************************************