Re: [PERFORM] Vacuum and Memory Loss

2006-10-23 Thread Jim C. Nasby
On Mon, Oct 23, 2006 at 09:45:59AM +0100, Richard Huxton wrote: > Mike wrote: > >Hello friends, > > > >I am responsible for maintaining a high volume website using postgresql > >8.1.4. Given the amount of reads and writes, I vacuum full the server a > >few times a week around 1, 2 AM shutting down

Re: [PERFORM] Vacuum and Memory Loss

2006-10-23 Thread Richard Huxton
Mike wrote: Hello friends, I am responsible for maintaining a high volume website using postgresql 8.1.4. Given the amount of reads and writes, I vacuum full the server a few times a week around 1, 2 AM shutting down the site for a few minutes. The next day morning around 10 - 11 AM the server s

Re: [PERFORM] Vacuum and Memory Loss

2006-10-22 Thread Dave Dutcher
> Hello friends, > > I am responsible for maintaining a high volume website using > postgresql > 8.1.4. Given the amount of reads and writes, I vacuum full > the server a > few times a week around 1, 2 AM shutting down the site for a few > minutes. The next day morning around 10 - 11 AM the serv

[PERFORM] Vacuum and Memory Loss

2006-10-20 Thread Mike
Hello friends, I am responsible for maintaining a high volume website using postgresql 8.1.4. Given the amount of reads and writes, I vacuum full the server a few times a week around 1, 2 AM shutting down the site for a few minutes. The next day morning around 10 - 11 AM the server slows down to d