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
>
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