From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Update table performance
Date: Tue, 7 Aug 2007 09:03:49 -0700
Message-ID: <200708070903.50096@hal.medialogik.com> (raw)
In-Reply-To: <435532.80672.qm@web32210.mail.mud.yahoo.com>
References: <435532.80672.qm@web32210.mail.mud.yahoo.com>
On Tuesday 07 August 2007 05:58, Mark Makarowsky
<bedrockconstruction@yahoo.com> wrote:
> I have a table with 4,889,820 records in it. The
> table also has 47 fields. I'm having problems with
> update performance. Just as a test, I issued the
> following update:
>
> update valley set test='this is a test'
>
> This took 905641 ms. Isn't that kind of slow?
PostgreSQL has to write a full new version of every row that gets updated.
Updates are, therefore, relatively slow.
I'm guessing you're doing this on a single SATA drive, too, which probably
doesn't help.
--
"If a nation values anything more than freedom, it will lose its freedom;
and the irony of it is that if it is comfort or money that it values more,
it will lose that too." -- Somerset Maugham, Author
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: Update table performance
In-Reply-To: <200708070903.50096@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox