Re: Simple join doesn't use index - Mailing list pgsql-performance

From Filip Rembiałkowski
Subject Re: Simple join doesn't use index
Date
Msg-id CAP_rwwk2JVR6gFZs_j7ASPMctB3xbUeEfVCyiVbrJiKOjZ+eLg@mail.gmail.com
Whole thread Raw
In response to Re: Simple join doesn't use index  (Alex Vinnik <alvinnik.g@gmail.com>)
Responses Re: Simple join doesn't use index
Re: Simple join doesn't use index
List pgsql-performance

On Mon, Jan 28, 2013 at 5:43 PM, Alex Vinnik <alvinnik.g@gmail.com> wrote:
It sure turned out that default settings are not a good fit.

do you know pgtune?
it's a good tool for starters, if you want a fast postgres and don't really want to learn what's behind the scenes.

random_page_cost=1 might be not what you really want.
it would mean that random reads are as fast as as sequential reads, which probably is true only for SSD


Filip

pgsql-performance by date:

Previous
From: Alex Vinnik
Date:
Subject: Re: Simple join doesn't use index
Next
From: Merlin Moncure
Date:
Subject: Re: Simple join doesn't use index