pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
To: pgsql-admin@postgresql.org
Subject: Re: very, very slow performance
Date: Sat, 21 Feb 2009 14:45:24 +0100
Message-ID: <49A00574.3060702@gmx.de> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F77A@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F760@egcrc-ex01.egcrc.org>
	<dcc563d10902192148s7f781086p1c0a469e0ebc1dc5@mail.gmail.com>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F774@egcrc-ex01.egcrc.org>
	<200902202145.49391.uwe@oss4u.com>
	<dcc563d10902210057k329f93bat76d07ba0016a24fe@mail.gmail.com>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F77A@egcrc-ex01.egcrc.org>

Hello,

> I have adjusted postgres parameters per your recommen-
> dation.  Work_mem is now 8GB,

GB is just a typo I guess? Otherwise the value is insanely high. See:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html

Peter

view thread (13+ messages)  latest in thread

Message-ID: <49A00574.3060702@gmx.de>
Permalink:  ../49A00574.3060702@gmx.de/
Also on:    postgresql.org/message-id/49A00574.3060702@gmx.de

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Jan-Peter.Seifert@gmx.de, tsakai@gallo.ucsf.edu
  Subject: Re: very, very slow performance
  In-Reply-To: <49A00574.3060702@gmx.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox