om: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, November 18, 2005 3:08 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Size, vacuum, performance, etc
Niblett, David A wrote:
> As for the dbmail-util, I would love not to run that part each night,
> but I thought that was rec
Niblett, David A wrote:
> As for the dbmail-util, I would love not to run that part each
> night, but I thought that was recommended. Maybe Paul or one
> of the other developers could shed some light on the recommended
> dbmail-util schedule. I checked my logs and I've never had a
> single mess
Niblett, David A wrote:
Wow, then I'm completely lost looking at your numbers.
I set my shmall and shmmax to 805306368, so that the DB (which
is the only thing using memory on the box) could have 800M of
shared RAM. Am I crazy here?
PostgreSQL uses it's shared buffers for some internal ope
blett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Jesse Norell [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 17, 2005 2:34 PM
To: DBMail m
Hello,
The postgres setup I'm referring here is the same that Dave Logan
replied about earlier, fyi. We have no postgres experts on staff,
just Dave and I, and we do what we can. As of 7.4, unbounded growth
problems have gone away and with some trial and error, we've not had
any major database
hone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Dave Logan [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 17, 2005 11:55 AM
To: DBMail mailinglist
Cc: [EMAIL PROTECTED]
Subject: Re: [Dbmail] Size, vacuum, performance, etc
I don't think there is any need to take this off list, I think there are
lot of people who would like to hear this discussion. Anyway I don't
run a dbmail site with that much load, however I to have a fair amount
of experience running PostgreSQL.
1) Never vacuum FULL: If you are vacuuming oft
> So if there is anyone on the list that is using dbmail 2.0
> with PostgreSQL (8.x) with 5k+ users, and a data set of around
> 20G would you contact me off list if you like.
>
We have around that for dataset/userbase, but are using dbmail 1.2.
I'll answer your questions anyway.
First off, we're r
