Best tweak for fast results.. ?

From: JM <jerome(at)gmanmi(dot)tv>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Best tweak for fast results.. ?
Date: 2003-08-26 13:42:52
Message-ID: 200308262142.52521.jerome@gmanmi.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2003-08-26 13:47:44 Re: is linux ready for databases ? (Ziff Davis article
Previous Message Alvaro Herrera Munoz 2003-08-26 13:31:09 Re: Database recovery after fs crash

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-08-26 15:47:52 Re: Query too slow
Previous Message Jeff 2003-08-26 12:34:01 Sun vs a P2. Interesting results.