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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to