MVCC for massively parallel inserts

From: Steven D(dot)Arnold <stevena(at)neosynapse(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: MVCC for massively parallel inserts
Date: 2004-01-06 02:11:43
Message-ID: AC0C3812-3FED-11D8-B06E-000A95D9F944@neosynapse.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How good is Postgres' performance for massive simultaneous insertions
into the same heavily-indexed table? Are there any studies or
benchmarks I can look at for that?

I understand Postgres uses MVCC rather than conventional locking, which
makes it easier to do parallel inserts. In my environment, I will have
so many inserts that it is unworkable to have one machine do all the
inserting -- it would max out the CPU of even a very powerful machine,
and in any case I'd like to avoid spending that much money. One option
is to use a cluster of commodity Intel machines running Linux or one of
the BSD's. In many database environments, that wouldn't buy me much
because only one machine could do inserts while all the others would be
used for selects. But I'm going to have tons of inserts and few
selects. So I really need many of the machines in the cluster to be
able to simultaneously insert. Is this practicable in a clustered
environment for Postgres?

Thanks in advance for any insight or references,
steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-01-06 02:19:15 Re: Paypal WAS: PostgreSQL speakers needed for OSCON
Previous Message Robert Bernier 2004-01-06 00:20:26 Re: PostgreSQL speakers needed for OSCON 2004