> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly