View Single Post

   
  #2 (permalink)  
Old 04-19-2008, 09:17 AM
Dave Dutcher
 
Posts: n/a
Default Re: Big diference in response time (query plan question)


> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailtogsql-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.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote