pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedConfiguration/Tuning of server/DB
2+ messages / 2 participants
[nested] [flat]
* Configuration/Tuning of server/DB
@ 2005-03-24 19:46 Reid Thompson <jreidthompson@earthlink.net>
0 siblings, 1 reply; 2+ messages in thread
From: Reid Thompson @ 2005-03-24 19:46 UTC (permalink / raw)
To: pgsql-performance
Using information found on the web, I've come up with some configuration
and tuning parameters for a server/db that we will be implementing. I
was wondering if I could generate some feedback as to configuration and
tuning so that I could compare my estimations with those of others.
Host is AIX 5.1 with 4 cpu's and 4 GB ram. Postgresql will be sharing
this machine with other processes. Storage is an EMC storage array.
The DB itself is very simple. Two tables, one with 40-45 columns (
largest column will likely contain no more than 32 chars of data ), the
other with less than 5 columns ( largest column will contain no more
than 20 chars data ). Expected transactions will be along the order of
~600K +- 100K inserts and ~600K +-200K updates per week.
Thanks
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Configuration/Tuning of server/DB
@ 2005-03-28 15:44 Thomas F.O'Connell <tfo@sitening.com>
parent: Reid Thompson <jreidthompson@earthlink.net>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas F.O'Connell @ 2005-03-28 15:44 UTC (permalink / raw)
To: Reid Thompson <jreidthompson@earthlink.net>; +Cc: pgsql-performance
Reid,
There are a few very valuable tuning documents that are part of the
established PostgreSQL-related literature. You don't mention which
version of postgres you'll be running, but here are the documents
you'll find useful:
postgresql.conf
7.4:
http://www.varlena.com/varlena/GeneralBits/Tidbits/
annotated_conf_e.html
8.0: http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
general tuning
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source — Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 24, 2005, at 1:46 PM, Reid Thompson wrote:
> Using information found on the web, I've come up with some
> configuration and tuning parameters for a server/db that we will be
> implementing. I was wondering if I could generate some feedback as to
> configuration and tuning so that I could compare my estimations with
> those of others.
>
> Host is AIX 5.1 with 4 cpu's and 4 GB ram. Postgresql will be sharing
> this machine with other processes. Storage is an EMC storage array.
> The DB itself is very simple. Two tables, one with 40-45 columns (
> largest column will likely contain no more than 32 chars of data ),
> the other with less than 5 columns ( largest column will contain no
> more than 20 chars data ). Expected transactions will be along the
> order of ~600K +- 100K inserts and ~600K +-200K updates per week.
>
> Thanks
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-28 15:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-24 19:46 Configuration/Tuning of server/DB Reid Thompson <jreidthompson@earthlink.net>
2005-03-28 15:44 ` Thomas F.O'Connell <tfo@sitening.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