pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Turner <armtuk@gmail.com>
To: Marc G. Fournier <scrappy@postgresql.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sustained inserts per sec ... ?
Date: Fri, 1 Apr 2005 16:17:19 -0500
Message-ID: <33c6269f05040113175b47b640@mail.gmail.com> (raw)
In-Reply-To: <20050401140421.P18194@ganymede.hub.org>
References: <20050401140421.P18194@ganymede.hub.org>

1250/sec with record size average is 26 bytes
800/sec with record size average is 48 bytes. 
250/sec with record size average is 618 bytes.

Data from pg_stats and our own job monitoring

System has four partitions, two raid 1s, a four disk RAID 10 and a six
disk RAID 10.
pg_xlog is on four disk RAID 10, database is on RAID 10.

Data is very spread out because database turnover time is very high,
so our performance is about double this with a fresh DB. (the data
half life is probably measurable in days or weeks).

Alex Turner
netEconomist

On Apr 1, 2005 1:06 PM, Marc G. Fournier <scrappy@postgresql.org> wrote:
> 
> Just curious, but does anyone have an idea of what we are capable of?  I
> realize that size of record would affect things, as well as hardware, but
> if anyone has some ideas on max, with 'record size', that would be
> appreciated ...
> 
> Thanks ...
> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>



view thread (44+ messages)  latest in thread

Message-ID: <33c6269f05040113175b47b640@mail.gmail.com>
Permalink:  ../33c6269f05040113175b47b640@mail.gmail.com/
Also on:    postgresql.org/message-id/33c6269f05040113175b47b640@mail.gmail.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: armtuk@gmail.com, scrappy@postgresql.org
  Subject: Re: Sustained inserts per sec ... ?
  In-Reply-To: <33c6269f05040113175b47b640@mail.gmail.com>

* 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