On Fri, Jul 8, 2011 at 9:44 AM, <Mamatha_Kagathi_Chan(at)dell(dot)com> wrote:
> ****
>
> Hi,****
>
> ** **
>
> Following is present in the postgresql.conf. ****
>
> ** **
>
> # - Memory -****
>
> ** **
>
> #shared_buffers = 32MB # min 128kB****
>
> shared_buffers = *902521* # min 128kB or max_connections*16kB
>
Yes - try setting it to 512MB.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company