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: (view raw, whole thread or download thread mbox)
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.)


In response to


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-2017 The PostgreSQL Global Development Group