Re: MemoryContextSwitchTo during table scan?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Jignesh Shah" <jigneshk(at)hotmail(dot)com>
Subject: Re: MemoryContextSwitchTo during table scan?
Date: 2005-08-22 19:12:56
Message-ID: 200508221212.57047.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jignesh,

> Also is there any way to optimize LockBuffer?

Yes, test on 8.1. The buffer manager was re-written for 8.1. You should
see a decrease in both LockBuffer and context switch activity.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-08-22 20:15:18 Re: complex query performance assistance request
Previous Message John Mendenhall 2005-08-22 18:21:38 Re: complex query performance assistance request