Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance query about large tables, lots of concurrent access - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance query about large tables, lots of concurrent access
Date
Msg-id 14291.1182221811@sss.pgh.pa.us
Whole thread Raw
In response to Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
Responses Re: Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Volunteer to build a configuration tool
Next
From: PFC
Date:
Subject: Re: Performance query about large tables, lots of concurrent access