Re: Slow table update

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: Gregory Williamson <Gregory(dot)Williamson(at)digitalglobe(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow table update
Date: 2008-12-22 13:27:58
Message-ID: 494F95DE.1060605@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I just tested the same on a test machine. It only has one processor 1GB
memory, and one SATA disk. The same "select count(*)" was 58 seconds. I
started the same UPDATE with EXPLAIN ANALYZE. It is running since 1000
seconds. I'm now 100% sure that the problem is with the database,
because this machine has nothing but a postgresql server running on it.
I'll post the output of explain analyze later.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-12-22 13:30:22 Re: Slow table update
Previous Message Alvaro Herrera 2008-12-22 13:27:21 Re: rebellious pg stats collector (reopened case)