From: David Hill <davidh@wmis.net>
To: pgsql-performance@postgresql.org
Subject: freebsd 5.2 and max_connections
Date: Tue, 13 Jan 2004 11:04:13 -0500
Message-ID: <20040113160413.GB1554@phobia.ms> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: davidh@wmis.net
Subject: Re: freebsd 5.2 and max_connections
In-Reply-To: <20040113160413.GB1554@phobia.ms>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox