pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron Johnson <ron.l.johnson@cox.net>
To: PgSQL General ML <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] Best tweak for fast results.. ?
Date: Tue, 26 Aug 2003 12:11:41 -0500
Message-ID: <1061917901.18108.109.camel@haggis> (raw)
In-Reply-To: <200308262142.52521.jerome@gmanmi.tv>
References: <200308262142.52521.jerome@gmanmi.tv>

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.l.johnson@cox.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




view thread (5+ messages)  latest in thread

Message-ID: <1061917901.18108.109.camel@haggis>
Permalink:  ../1061917901.18108.109.camel@haggis/
Also on:    postgresql.org/message-id/1061917901.18108.109.camel@haggis

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: ron.l.johnson@cox.net, pgsql-general@postgresql.org
  Subject: Re: [PERFORM] Best tweak for fast results.. ?
  In-Reply-To: <1061917901.18108.109.camel@haggis>
  References: <200308262142.52521.jerome@gmanmi.tv> <1061917901.18108.109.camel@haggis>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox