slow full table update - Mailing list pgsql-performance

From
Subject slow full table update
Date
Msg-id 200811101730.15902@centrum.cz
Whole thread Raw
Responses Re: slow full table update  (tv@fuzzy.cz)
Re: slow full table update  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
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







pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple indexed IN query takes 40 seconds
Next
From: tv@fuzzy.cz
Date:
Subject: Re: slow full table update