Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-performance by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group