Postgres Pro
Downloads
Home   >   mailing lists

Re: Howto Increased performace ? - Mailing list pgsql-performance

From Iain
Subject Re: Howto Increased performace ?
Date
Msg-id 00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to Howto Increased performace ?  ("Amrit Angsusingh" <amrit@spr.go.th>)
List pgsql-performance
Tree view 
Hi,

> #sort_mem = 1024 # min 64, size in KB
> sort_mem = 60000

I think this might be too much. You are using 60000KB _per connection_ here
= 10GB for your maximum of 180 connections.

By comparison, I am specifiying 4096 (subject to adjustment) for a machine
with a similar spec to yours.

regards
Iain

pgsql-performance by date:

Previous
From: Ragnar Hafstað
Date:
Subject: Re: Speed in V8.0
Next
From: "Iain"
Date:
Subject: Re: Howto Increased performace ?