pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Rhaoni Chiu Pereira <rhaoni@sistemica.info>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Low Insert/Update Performance
Date: Wed, 22 Oct 2003 09:27:49 -0700
Message-ID: <200310220927.49451.josh@agliodbs.com> (raw)
In-Reply-To: <1066839697.3f96ae91e3108@sistemica.info>
References: <1066659206.3f93ed86b9907@sistemica.info>
<200310211013.53997.josh@agliodbs.com>
<1066839697.3f96ae91e3108@sistemica.info>
Rhaoni,
> Total runtime: 3.56 msec
> (4 rows)
Well, from that figure it's not the query that's holding you up.
You said that the system bogs down when you're doing a whole series of these
updates, or just one? If the former, then I'm afraid that it's your disk
that's to blame ... large numbers of rapid-fire updates simply won't be fast
on a single IDE disk. Try getting a second disk and moving the transaction
log to it.
--
Josh Berkus
Aglio Database Solutions
San Francisco
view thread (8+ messages) latest in thread
Message-ID: <200310220927.49451.josh@agliodbs.com> Permalink: ../200310220927.49451.josh@agliodbs.com/ Also on: postgresql.org/message-id/200310220927.49451.josh@agliodbs.com ·
reply
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 from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-performance@postgresql.org Cc: josh@agliodbs.com, rhaoni@sistemica.info Subject: Re: Low Insert/Update Performance In-Reply-To: <200310220927.49451.josh@agliodbs.com> References: <1066659206.3f93ed86b9907@sistemica.info> <200310211013.53997.josh@agliodbs.com> <1066839697.3f96ae91e3108@sistemica.info> <200310220927.49451.josh@agliodbs.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