Skip site navigation (1) Skip section navigation (2)

Re: Howto Increased performace ?

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "Amrit Angsusingh" <amrit(at)spr(dot)go(dot)th>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Howto Increased performace ?
Date: 2004-12-27 01:29:54
Message-ID: 00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb (view raw or flat)
Thread:
Lists: pgsql-performance
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





In response to

Responses

pgsql-performance by date

Next:From: IainDate: 2004-12-27 09:34:45
Subject: Re: Howto Increased performace ?
Previous:From: Karl VogelDate: 2004-12-26 12:30:15
Subject: Re: Why so much time difference with a same query/plan?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group