Re: Slow SELECT

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To:
Cc: pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow SELECT
Date: 2003-10-09 07:36:14
Message-ID: 3F850FEE.1060602@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-10-09 07:36:55 Re: int1?
Previous Message Shridhar Daithankar 2003-10-09 07:19:07 Re: int1?