> -----Original Message----- > From: pgsql-performance-owner@xxxxxxxxxxxxxx > [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] 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.
