Re: Big diference in response time (query plan question) - Mailing list pgsql-performance

From Dave Dutcher
Subject Re: Big diference in response time (query plan question)
Date
Msg-id 00ab01c6c143$69499f40$8300a8c0@tridecap.com
Whole thread Raw
In response to Re: Big diference in response time (query plan question)  ("Luiz K. Matsumura" <luiz@planit.com.br>)
List pgsql-performance
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> Luiz K. Matsumura
>
>
> Where I can see the current random_page_cost value ? There
> are some hint
> about what value I must set ?
> Thanks in advance.
> Luiz

On Linux the random_page_cost is set in the postgresql.conf file.  You can
see what it is set to by typing "show random_page_cost".  This page has some
guidelines on random_page_cost and other server settings:

http://www.powerpostgresql.com/PerfList/

As it says on the page, make sure you test a variety of queries.


pgsql-performance by date:

Previous
From: "Bucky Jordan"
Date:
Subject: Re: Dell PowerEdge 2950 performance
Next
From: "Carl Youngblood"
Date:
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2