Re: [GENERAL] Getting all tables into memory

2008-01-24 Thread Stefan Kaltenbrunner
Robert Fitzpatrick wrote: I have a couple of servers running Postfix with amavisd-maia+SA+clamav on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My issue is the bayes database causing SA TIMED OUT in the logs and want to make sure I am getting everything into memory. The disk ac

Re: [GENERAL] Getting all tables into memory

2008-01-24 Thread Robert Fitzpatrick
On Thu, 2008-01-24 at 10:46 -0500, Bill Moran wrote: > In response to Robert Fitzpatrick <[EMAIL PROTECTED]>: > > > How can I tell if PgSQL is using memory or not and > > how much? > > Well, top is helpful. Also, consider installing the pg_buffercache addon > so you can see how much of your shar

Re: [GENERAL] Getting all tables into memory

2008-01-24 Thread Bill Moran
In response to Robert Fitzpatrick <[EMAIL PROTECTED]>: > I have a couple of servers running Postfix with amavisd-maia+SA+clamav > on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My > issue is the bayes database causing SA TIMED OUT in the logs and want to > make sure I am getting

[GENERAL] Getting all tables into memory

2008-01-24 Thread Robert Fitzpatrick
I have a couple of servers running Postfix with amavisd-maia+SA+clamav on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My issue is the bayes database causing SA TIMED OUT in the logs and want to make sure I am getting everything into memory. The disk activity is high on the db ser