Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Big diference in response time (query plan question)
- From: "Dave Dutcher" <dave(at)tridecap(dot)com>
- To: "'Luiz K. Matsumura'" <luiz(at)planit(dot)com(dot)br>
- Cc: <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Big diference in response time (query plan question)
- Date: Wed, 16 Aug 2006 09:51:09 -0500
> -----Original Message----- > From: pgsql-performance-owner(at)postgresql(dot)org > [mailto:pgsql-performance-owner(at)postgresql(dot)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.
- References:
- Re: Big diference in response time (query plan question)
- From: Luiz K. Matsumura
- Re: Big diference in response time (query plan question)
- Prev by Date: Re: Dell PowerEdge 2950 performance
- Next by Date: Re: Beginner optimization questions, esp. regarding Tsearch2
- Previous by thread: Re: Big diference in response time (query plan question)
- Next by thread: PostgreSQL runs a query much slower than BDE and MySQL
- Indexes: