Re: [GENERAL] VACUUM, 24/7 availability and 7.2

2001-10-12 Thread Erwin Lansing
ave you searched our list archives? > > http://archives.postgresql.org > > > > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAI

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

2001-10-12 Thread Erwin Lansing
ave you searched our list archives? > > http://archives.postgresql.org > > > > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL

Re: [GENERAL] Perfomance decreasing

2001-08-20 Thread Erwin Lansing
analyze, and run a normal vacuum twice a day. The files are no longer growing since. I'm leaving for hollidays now, I'll investigate more when I return next week. /erwin > > > > > Erwin Lansing <[EMAIL PROTECTED]> on 08/14/2001 04:38:59 AM > > To: [EMAIL

Re: [GENERAL] Perfomance decreasing

2001-08-14 Thread Erwin Lansing
n to the size of the database in the filesystem, where problems start occurring when it exceeds 1,4 Gb. A dump/drop/create/restore reduces files size to approx. 350 Mb. Any pointers would be helpful as a weekly dump/restore is not quite optimal :) /erwin -- Erwin Lansing --