Horton

Re: RESOLVED: Re: Wierd context-switching issue on Xeon

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Dirk Lutzebäck <lutzeb@aeccom.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org
Cc: Sven Geisler <sgeisler@aeccom.com>
Date: 2004-04-16T16:58:14Z
Lists: pgsql-performance 
Dirk,

> I'm not sure if this semop() problem is still an issue but the database 
> behaves a bit out of bounds in this situation, i.e. consuming system 
> resources with semop() calls 95% while tables are locked very often and 
> longer.

It would be helpful to us if you could test this with the indexes disabled on 
the non-Bigmem system.   I'd like to eliminate Bigmem as a factor, if 
possible.

-- 
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
    Enterprise vertical business        josh@agliodbs.com
     and data analysis solutions        (415) 752-2387
      and database optimization           fax 651-9224
  utilizing Open Source technology      San Francisco