Postgres Pro
Downloads
Home   >   mailing lists

Thread: process time of update

process time of update

From
Peter Choe
Date:
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

Re: process time of update

From
Doug McNaught
Date:
Peter Choe <choepete@mindspring.com> writes:

> 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?

1) Are you running VACUUM regularly?

2) You are way, way, way out of date.  6.5.3 is at least five years old
   and has known bugs.  You will see a lot of improvements in
   functionality and performance if you upgrade to 7.2.3 or the
   upcoming 7.3 release.

-Doug

Re: process time of update

From
Peter Choe
Date:
i am upgrading the version soon, but i still need this one running until i
have the new server set up.

i thought i was running VACUUM regularly, but i need to check it again.

thanks for the help.

At 09:09 AM 11/26/2002, Doug McNaught wrote:
>Peter Choe <choepete@mindspring.com> writes:
>
> > 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?
>
>1) Are you running VACUUM regularly?
>
>2) You are way, way, way out of date.  6.5.3 is at least five years old
>    and has known bugs.  You will see a lot of improvements in
>    functionality and performance if you upgrade to 7.2.3 or the
>    upcoming 7.3 release.
>
>-Doug

Re: process time of update

From
"Williams, Travis L, NPONS"
Date:
Have you vacuumed the DB?

Travis

-----Original Message-----
From: Peter Choe [mailto:choepete@mindspring.com]
Sent: Tuesday, November 26, 2002 7:49 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] process time of update


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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: process time of update

From
Tom Lane
Date:
Doug McNaught <doug@mcnaught.org> writes:
> Peter Choe <choepete@mindspring.com> writes:
>> 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.

> 1) Are you running VACUUM regularly?

If vacuum doesn't help, try dropping and recreating the indexes on the
most-updated tables.

> 2) You are way, way, way out of date.

Indeed.

            regards, tom lane