Re: slow full table update - Mailing list pgsql-performance

On Mon, Nov 10, 2008 at 9:30 AM,  <firerox@centrum.cz> wrote:
> 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 :(

What does

vacuum verbose table;

say?  I'm wondering if it's gotten overly bloated.

How long does

select count(*) from table;

take to run (use \timing to time it)