Postgres Pro
Downloads
Home   >   mailing lists

Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Any better plan for this query?..
Date
Msg-id 1242659279.14551.7.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
Responses Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
List pgsql-performance
Tree view 
On Thu, 2009-05-14 at 20:25 +0200, Dimitri wrote:

> # lwlock_wait_8.4.d `pgrep -n postgres`

>                Lock Id            Mode   Combined Time (ns)
>       FirstLockMgrLock       Exclusive                 803700
>        BufFreelistLock       Exclusive                 3001600
>       FirstLockMgrLock          Shared               4586600
>  FirstBufMappingLock       Exclusive              6283900
>  FirstBufMappingLock          Shared             21792900

I've published two patches to -Hackers to see if we can improve the read
only numbers on 32+ cores.

Try shared_buffer_partitions = 256

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: superlative missuse
Next
From: Simon Riggs
Date:
Subject: Re: Any better plan for this query?..