Postgres Pro
Downloads
Home   >   mailing lists

postgres taking longer to update - Mailing list pgsql-general

From choepete@mindspring.com (peter)
Subject postgres taking longer to update
Date
Msg-id 8317cb71.0211260523.61d15a0e@posting.google.com
Whole thread Raw
List pgsql-general
Tree view 
i have a postgres database (version 6.5.3) that gets update by a Java
program every night.

it seems that each time the update is done it always takes a bit
longer to complete the process.  when it first started it took about 2
minutes.  now it takes about 2 hours to do the update.  is there
something i can do to bring down the time it takes to update the
database?

Peter Choe

pgsql-general by date:

Previous
From: "Damjan Pipan"
Date:
Subject: modifying new tuple on insert in c trigger
Next
From: Neil Conway
Date:
Subject: Re: EXECUTE problems