Re: MVCC for massively parallel inserts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steven D(dot)Arnold" <stevena(at)neosynapse(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MVCC for massively parallel inserts
Date: 2004-01-06 02:26:01
Message-ID: 6371.1073355961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Steven D.Arnold" <stevena(at)neosynapse(dot)net> writes:
> 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?

No.

You are mistaken to think that CPU is the bottleneck, anyway. It is
going to be disk bandwidth that's your problem, and throwing more CPUs
at it would not help. If your insert load exceeds the available disk
bandwidth, I think you have little choice but to figure out a way to
divide the workload among multiple independent databases.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-01-06 02:49:03 Re: MVCC for massively parallel inserts
Previous Message Joshua D. Drake 2004-01-06 02:19:15 Re: Paypal WAS: PostgreSQL speakers needed for OSCON