Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: 7.3.1 New install, large queries are slow
Date
Msg-id 4981.1042783570@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.1 New install, large queries are slow  ("Roman Fail" <rfail@posportal.com>)
Responses Re: 7.3.1 New install, large queries are slow  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-performance
Tree view 
"Roman Fail" <rfail@posportal.com> writes:
> shared_buffers = 131072

Yipes!  Try about a tenth that much.  Or less.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Roman Fail"
Date:
Subject: Re: 7.3.1 New install, large queries are slow
Next
From: Stephan Szabo
Date:
Subject: Re: 7.3.1 New install, large queries are slow