Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 79DCD64FCF8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 10 Nov 2008 12:30:34 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 19758-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 10 Nov 2008 12:30:34 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail1011.centrum.cz (mail1011.centrum.cz [90.183.38.141])
	by mail.postgresql.org (Postfix) with ESMTP id 8E4EB64FC77
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Nov 2008 12:30:33 -0400 (AST)
Received: by mail1011.centrum.cz id S537238324AbYKJQa2 (ORCPT
	<rfc822;pgsql-performance@postgresql.org>);
	Mon, 10 Nov 2008 17:30:28 +0100
Received: from 147.32.124.245 (X-Forwarded-For: 147.32.124.245)
	by mail1011.centrum.cz (Centrum Mail) with HTTP
Date: Mon, 10 Nov 2008 17:30:28 +0100
From: <firerox@centrum.cz>
To: <pgsql-performance@postgresql.org>
X-Mailer: Centrum Mail 5.0
MIME-Version: 1.0
X-Priority: 3
Message-ID: <200811101730.15902@centrum.cz>
References: <200811101728.3048@centrum.cz> <200811101729.14977@centrum.cz>
	<200811101730.11057@centrum.cz>
In-Reply-To: <200811101730.11057@centrum.cz>
Subject: slow full table update
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200811/61
X-Sequence-Number: 31792

Hi,

I have table with cca 60.000 rows and
when I run query as:
 Update table SET column=0;
after 10 minutes i must stop query, but it still running :(

I've Postgres 8.1 with all default settings in postgres.conf

Where is the problem?

Thak you for any tips.

best regards.
Marek Fiala