Tom Lane wrote:
=?ISO-8859-1?Q?Christian_Schr=F6der?= <cs@xxxxxxxxx> writes:
I don't want to "kill -9" the processes because the last time
I did this the database was in recovery mode for a substantial amount of
time.
A useful tip on that: if you perform a manual CHECKPOINT just before
issuing the kills, recovery time should be minimal.
Thanks for the tip. For the moment, I will leave the processes in their
current state to be able to perform further tests in case you need more
data. But when I will start feeling uncomfortable with the situation I
will follow your advice.
Regards,
Christian
--
Deriva GmbH Tel.: +49 551 489500-42
Financial IT and Consulting Fax: +49 551 489500-91
Hans-Böckler-Straße 2 http://www.deriva.de
D-37079 Göttingen
Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
