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

Re: What does this tell me?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Sean Chittenden <sean(at)chittenden(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: What does this tell me?
Date: 2002-10-09 04:55:21
Message-ID: 3DA3B6B9.4010207@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-performance
Josh Berkus wrote:
> What the function is doing is a succession of data cleanup procedures,
> updating the same table about 50 times.  I will be very thankful for
> the day when I can commit within a procedure.

If that's the case, can you split the work up into multiple functions, and 
execute them all from a shell script? Or perhaps even offload some of the data 
massaging to perl or something? (It would be easier to recommend alternate 
approaches with more details.)

Joe



In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2002-10-09 05:22:26
Subject: Re: What does this tell me?
Previous:From: Bruce MomjianDate: 2002-10-09 04:38:10
Subject: Re: What does this tell me?

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