Hello - I am using postgresql to hold aliases, users, and relay_domains for postfix and courier to do lookups from. I am not storing mail in sql.
I need postgresql to have fast read performance, so i setup index's on the tables. Also, the queries are basically "select blah from table where domain='domain.com'";, so i dont need to be able to support large results. I will have a lot of mail servers connecting to this postgresql db, so i need to support a lot of connections... but dont need to support large results. I am using FreeBSD 5.2. What are some tuning options and formulas I can use to get good values? Thanks! David ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])