Re: 7.3.1 New install, large queries are slow

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Roman Fail" <rfail(at)posportal(dot)com>
Cc: sszabo(at)megazone23(dot)bigpanda(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: 7.3.1 New install, large queries are slow
Date: 2003-01-17 17:08:54
Message-ID: web-2317350@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

> > shared_buffers = 131072
>
> Yipes! Try about a tenth that much. Or less.

Why? He has 4GB RAM on the machine.

-Josh Berkus

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Noah Silverman 2003-01-17 17:28:35 Strange Join question
Previous Message Andrew Sullivan 2003-01-17 15:41:10 Re: Implicit casting and JOIN syntax constraints