Re: Slow SELECT - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Slow SELECT
Date
Msg-id 3F850FEE.1060602@persistent.co.in
Whole thread Raw
In response to Re: Slow SELECT  (Mat <psql-mail@freeuk.com>)
List pgsql-general
Mat wrote:
> Lines from postgresql.conf that don't start with a '#':
>
> tcpip_socket = true
> shared_buffers = 126976     #992 MB
> sort_mem = 36864                #36 MB
> vacuum_mem = 73696              #72 MB

I would suggest scale down shared buffers to 128 or 64MB and set effective cache
size correct. That should help.

HTH

  Shridhar


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: int1?
Next
From: Ron Johnson
Date:
Subject: Re: int1?