pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedfreebsd 5.2 and max_connections
2+ messages / 2 participants
[nested] [flat]
* freebsd 5.2 and max_connections
@ 2004-01-13 16:04 David Hill <davidh@wmis.net>
2004-01-13 17:13 ` Re: freebsd 5.2 and max_connections Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 2+ messages in thread
From: David Hill @ 2004-01-13 16:04 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: freebsd 5.2 and max_connections
2004-01-13 16:04 freebsd 5.2 and max_connections David Hill <davidh@wmis.net>
@ 2004-01-13 17:13 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2004-01-13 17:13 UTC (permalink / raw)
To: David Hill <davidh@wmis.net>; pgsql-performance
On Tuesday 13 January 2004 16:04, David Hill wrote:
> 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.
Firstly - if you don't know about the tuning guidelines/annotated config file,
you should go here:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
Hmm - small result sets accessed directly via indexed fields, so sort_mem
probably isn't important to you.
Make sure your effective cache setting is accurate though, so PG can estimate
whether it'll need to access the disks.
Not sure if clustering one or more tables will help - I'm guessing not. What
might help is to increase the statistics gathered on important columns. That
should give the planner a more accurate estimate of value distribution and
shouldn't cost you too much to keep accurate, since I'm guessing a low rate
of updating.
You might want to play with the random page cost (?or is it random access
cost?) but more RAM for a bigger disk cache is probably the simplest tweak.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-13 17:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-13 16:04 freebsd 5.2 and max_connections David Hill <davidh@wmis.net>
2004-01-13 17:13 ` Richard Huxton <dev@archonet.com>
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