From: lst_hoe02@kwsoft.de
To: pgsql-admin@postgresql.org
Subject: Re: Maximum insert per second
Date: Fri, 15 Jul 2011 10:09:26 +0200
Message-ID: <20110715100926.91335pd1uvzhoz8c@webmail.kwsoft.de> (raw)
In-Reply-To: <4E1C0C9C020000250003F225@gw.wicourts.gov>
References: <CANqFkjHxz7dwBgQhzUgO2SABDBs_Nn+DzVEq4UsGhuMtURXfqA@mail.gmail.com>
<4E1C0C9C020000250003F225@gw.wicourts.gov>
Zitat von Kevin Grittner <Kevin.Grittner@wicourts.gov>:
> Jenish Vyas <jenishvyas@gmail.com> wrote:
>
>> I am able to insert 1190- 1210 records per seconds.
>>
>> Now I just want to know by what extend I could stretch it.
>>
>> What is the maximum insert I can achieve in one second? What is
>> the maximum number of insert postgresql achieved so far?
>
> I don't have hard numbers handy, and I know I don't have the fastest
> hardware out there, but for bulk loads of narrow tables we typically
> see tens of thousands of rows per second. Of course that's with
> "running with scissors" settings. We turn off archiving,
> autovacuum, fsync, full_page_writes, and synchronous_commit; and
> COPY rows within the same transaction which creates the table,
> before creating any indexes. Then we build the indexes, VACUUM
> FREEZE ANALYZE, and change back to a configuration which actually
> preserves the data on a crash.
>
> From memory, I would say on our larger servers we've probably seen
> a max of something on the order of 50,000 rows per second on
> relatively narrow tables, without factoring the index build and
> vacuum times.
>
Are there any numbers around for OLTP like systems? Would be nice to
know what is possible with PostgreSQL in this case.
Regards
Andreas
Attachments:
smime.p7s (application/pkcs7-signature, 5.9K) download
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-admin@postgresql.org
Cc: lst_hoe02@kwsoft.de
Subject: Re: Maximum insert per second
In-Reply-To: <20110715100926.91335pd1uvzhoz8c@webmail.kwsoft.de>
* 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