Re: slow full table update

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: firerox(at)centrum(dot)cz
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow full table update
Date: 2008-11-12 20:55:52
Message-ID: dcc563d10811121255h7d788032v4a8aa24c9db523b8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 10, 2008 at 9:30 AM, <firerox(at)centrum(dot)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)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-11-12 20:57:38 Re: Performance Question
Previous Message Tom Lane 2008-11-12 20:54:08 Re: slow full table update