Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.3.1 New install, large queries are slow - Mailing list pgsql-performance

From Josh Berkus
Subject Re: 7.3.1 New install, large queries are slow
Date
Msg-id web-2317350@davinci.ethosmedia.com
Whole thread Raw
In response to Re: 7.3.1 New install, large queries are slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Strange Join question  (Noah Silverman <noah@allresearch.com>)
Re: 7.3.1 New install, large queries are slow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Tom,

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

Why?  He has 4GB RAM on the machine.

-Josh Berkus

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Implicit casting and JOIN syntax constraints
Next
From: Noah Silverman
Date:
Subject: Strange Join question