appropriate sort_mem & shared buffers

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: appropriate sort_mem & shared buffers
Date: 2001-12-21 17:05:31
Message-ID: 1008954332.19976.8.camel@entwicklung01.cenes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

for a machine with 2 gig mem (1ghz pIII) is
sort_mem = 128 # 64 Mebibyte
shared_buffers = 65536 # 512 Mebibyte
appropriate and reasonable?

Markus Bertheau

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Albert REINER 2001-12-21 17:20:12 Re: concating numeric with text
Previous Message Josh Berkus 2001-12-21 16:37:00 Re: Import DB from DOS- dbase4