From: Dave Cramer <pg@fastcrypt.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
Cc: pgsql-performance@postgresql.org
Subject: Re: 500 requests per second
Date: Mon, 21 May 2007 20:52:43 -0400
Message-ID: <BA544273-5925-40E7-A8CB-ABBC462BF7E9@fastcrypt.com> (raw)
In-Reply-To: <b42b73150705211250w61f9737ele7c498d8e1517ed3@mail.gmail.com>
References: <Pine.LNX.4.64.0705120936580.29679@oynpxoyhr.vnfv.npgvirzrqvngrpu.pbz>
<b42b73150705211250w61f9737ele7c498d8e1517ed3@mail.gmail.com>
> * set reasonable statement timeout
> * backup with pitr. pg_dump is a headache on extremely busy servers.
Where do you put your pitr wal logs so that they don't take up extra
I/O ?
> * get good i/o system for your box. start with 6 disk raid 10 and go
> from there.
> * spend some time reading about bgwriter settings, commit_delay, etc.
> * keep an eye out for postgresql hot (hopefully coming with 8.3) and
> make allowances for it in your design if possible.
> * normalize your database and think of vacuum as dangerous enemy.
>
> good luck! :-)
>
> merlin
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
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: pg@fastcrypt.com, mmoncure@gmail.com, mituc@iasi.rdsnet.ro
Subject: Re: 500 requests per second
In-Reply-To: <BA544273-5925-40E7-A8CB-ABBC462BF7E9@fastcrypt.com>
* 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