Postgres Pro
Downloads
Home   >   mailing lists

Re: MemoryContextSwitchTo during table scan? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: MemoryContextSwitchTo during table scan?
Date
Msg-id 200508221212.57047.josh@agliodbs.com
Whole thread Raw
In response to MemoryContextSwitchTo during table scan?  ("Jignesh Shah" <jigneshk@hotmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: John Mendenhall
Date:
Subject: Re: complex query performance assistance request
Next
From: Tom Lane
Date:
Subject: Re: complex query performance assistance request