From: Tom Lane <tgl@sss.pgh.pa.us>
To: Karl Wright <kwright@metacarta.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance query about large tables, lots of concurrent access
Date: Mon, 18 Jun 2007 22:56:51 -0400
Message-ID: <14291.1182221811@sss.pgh.pa.us> (raw)
In-Reply-To: <4676DD57.7070304@metacarta.com>
References: <4676DD57.7070304@metacarta.com>
Karl Wright <kwright@metacarta.com> writes:
> - At any given time, there are up to 100 of these operations going on at
> once against the same database.
It sounds like your hardware is far past "maxed out". Which is odd
since tables with a million or so rows are pretty small for modern
hardware. What's the CPU and disk hardware here, exactly? What do you
see when watching vmstat or iostat (as appropriate for OS, which you
didn't mention either)?
regards, tom lane
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: tgl@sss.pgh.pa.us, kwright@metacarta.com
Subject: Re: Performance query about large tables, lots of concurrent access
In-Reply-To: <14291.1182221811@sss.pgh.pa.us>
* 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