Postgres Pro
Downloads
Home   >   mailing lists

Best tweak for fast results.. ? - Mailing list pgsql-performance

From JM
Subject Best tweak for fast results.. ?
Date
Msg-id 200308262142.52521.jerome@gmanmi.tv
Whole thread Raw
Responses Re: Best tweak for fast results.. ?
Re: Best tweak for fast results.. ?
List pgsql-performance
Tree view 
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..


TIA

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query too slow
Next
From: Jeff
Date:
Subject: Sun vs a P2. Interesting results.