| From: | "Dave Dutcher" <dave(at)tridecap(dot)com> |
|---|---|
| To: | "'Luiz K(dot) 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: | 2006-08-16 14:51:09 |
| Message-ID: | 00ab01c6c143$69499f40$8300a8c0@tridecap.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> -----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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carl Youngblood | 2006-08-16 15:34:24 | Re: Beginner optimization questions, esp. regarding Tsearch2 |
| Previous Message | Bucky Jordan | 2006-08-16 14:45:13 | Re: Dell PowerEdge 2950 performance |