Ron Johnson wrote:
On Tue, 2003-08-26 at 08:42, JM wrote:
need input on parameter values on confs...
our database is getting 1000 transactions/sec on peak periods..
sitting on RH 7.3 2.4.7-10smp
RAM: 1028400
SWAP: 2040244
queries are just simple select statements based on timestamps, varchars...
less on joins... on a 300K rows..
Could it be that 1000tps is as good as your h/w can do? You didn't mention what kind and speed of CPU(s), SCSI-or-IDE controller(s) and type/speed of disk(s) you have.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
