Thread: postgres taking longer to 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
I've never used this version (6.5.3), but have you tried the 'vacuum' command? >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 > > > > -- Diogo de Oliveira Biazus diogo@ikono.com.br Ikono Sistemas e Automação http://www.ikono.com.br
In article <8317cb71.0211260523.61d15a0e@posting.google.com>, peter wrote: > i have a postgres database (version 6.5.3) that gets update by a Java > program every night. > You need to upgrade. I know 7.3 is only 0.8 more than 6.5 ((not even a whole 1 difference)) but I think it is more important than it may appear. If it is at all possible, upgrade.
Lee Harr wrote: > In article <8317cb71.0211260523.61d15a0e@posting.google.com>, peter wrote: > > i have a postgres database (version 6.5.3) that gets update by a Java > > program every night. > > > > You need to upgrade. > > > I know 7.3 is only 0.8 more than 6.5 ((not even a whole 1 difference)) > but I think it is more important than it may appear. > > > If it is at all possible, upgrade. Yes, only a 12% increase. ;-) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073