Re: [ADMIN] Database growth problem

2003-07-19 Thread Andrew Biagioni
7/18/03 10:06:29 AM, "scott.marlowe" <[EMAIL PROTECTED]> wrote: >On Thu, 17 Jul 2003, mlaks wrote: > >> Hi, >> >> I have about 15 different PC's running RedHat 7.3 Linux, each running the >> same database backed application (I use Postgresql 7.2.1 for the database) >> on each machine. > >Upg

Re: [ADMIN] Database growth problem

2003-07-18 Thread scott.marlowe
On Thu, 17 Jul 2003, mlaks wrote: > Hi, > > I have about 15 different PC's running RedHat 7.3 Linux, each running the > same database backed application (I use Postgresql 7.2.1 for the database) > on each machine. Upgrade to 7.2.4 as soon as possible. There are bugs in 7.2.3 and before th

Re: [ADMIN] Database growth problem

2003-07-18 Thread Andrew Sullivan
On Thu, Jul 17, 2003 at 10:32:24PM -0400, mlaks wrote: > Hi, > > I have about 15 different PC's running RedHat 7.3 Linux, each running the > same database backed application (I use Postgresql 7.2.1 for the database) Upgrade that to 7.2.4, at least. Noo need to dump and restore, but you get s

Re: [ADMIN] Database growth problem

2003-07-18 Thread Mendola Gaetano
"mlaks" <[EMAIL PROTECTED]> wrote: > But I run vaccuum analyze at the same frequency as on the PC's? How is it that > deleting and saving and vacuum analyze doesnt keep it at a normal svelte <1Gb > in size? > > What should I do to shrink it back down to its normal svelte shape? Did you try to vac