Re: Low Budget Performance, Part 2

From: eric soroos <eric-psql(at)soroos(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Low Budget Performance, Part 2
Date: 2002-11-28 18:11:19
Message-ID: 30918002.1173644217@[4.42.179.151]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > I'm suspect that the previous runs were colored by having the entire
> > dataset in memory as well as the update contention.
>
> A run of vmstat while the test is in progress might well show what's affecting
> performance here.

Unfortunately, vmstat on OSX is not what it is on Linux.

vm_stat on osx gives virtual memory stats, but not disk io or cpu load.
iostat looks promising, but is a noop.
Top takes 10 % of processor.

eric

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message eric soroos 2002-11-28 18:32:46 Re: Low Budget Performance, Part 2
Previous Message Justin Clift 2002-11-28 12:56:45 Re: Low Budget Performance, Part 2