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])

Reply via email to