Re: Urgent: Tuning strategies?

Hi,

-- Markus Wollny <Markus(dot)Wollny(at)computec(dot)de> wrote:

> How can we reduce swap-activity further, because I
> think it's quite high (see top-output)?

you may try to reduce the shared memory and sorting memory for postgres,
sometimes it's too high and it's better to not use too much shared memory.

Here are some hints for this topic:

http://www.ca.postgresql.org/docs/momjian/hw_performance/

> We do use
> EXPLAIN-output for finding out if our indexes are used or not (and it
> seems they are),

explain is not only interesting for checking the use of indexes; I use it
also to check if some queries took too long. With "explain analyze" in 7.2
you can measure the time which a query really needs, not only the estimated
time.

Ciao
Alvar

--
// Unterschreiben! http://www.odem.org/informationsfreiheit/
// Internet am Telefon: http://www.teletrust.info/
// Das freieste Medium? http://www.odem.org/insert_coin/
// Blaster: http://www.assoziations-blaster.de/