Re: Maximum insert per second

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Zitat von Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx>:

Jenish Vyas <jenishvyas@xxxxxxxxx> 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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux