Re: performance of insert/delete/update

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Wei Weng <wweng(at)kencast(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance of insert/delete/update
Date: 2002-11-23 04:18:22
Message-ID: web-1838339@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Scott,

> > > The absolutely most important thing to do to speed up inserts and
> > > updates
> > > is to squeeze as many as you can into one transaction.

I was discussing this on IRC, and nobody could verify this assertion.
Do you have an example of bunlding multiple writes into a transaction
giving a performance gain?

-Josh

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-11-23 06:04:14 regression failures
Previous Message Bruce Momjian 2002-11-23 04:06:38 Re: Fw: Missing file from CVS?

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2002-11-23 15:06:00 Re: performance of insert/delete/update
Previous Message scott.marlowe 2002-11-22 15:56:14 Re: performance of insert/delete/update