| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] Best tweak for fast results.. ? |
| Date: | 2003-08-26 17:11:41 |
| Message-ID: | 1061917901.18108.109.camel@haggis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Oh, great altar of passive entertainment, bestow upon me thy
discordant images at such speed as to render linear thought impossible"
Calvin, regarding TV
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-26 17:22:35 | Re: is linux ready for databases ? (Ziff Davis article |
| Previous Message | Andrew Sullivan | 2003-08-26 17:09:27 | Re: Linux ready for high-volume databases? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-26 17:25:28 | Re: [PERFORM] Best tweak for fast results.. ? |
| Previous Message | Tom Lane | 2003-08-26 16:01:32 | Re: Query too slow |