Re: Bitmap Heap scan 8.1/8.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Bitmap Heap scan 8.1/8.2
Date
Msg-id 10734.1193149332@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bitmap Heap scan 8.1/8.2  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Martin Marques escribi�:
>>> seq_page_cost = 5.0                     # measured on an arbitrary scale

> What people generally do around here is mess with random_page_cost, and
> leave seq_page_cost alone.

It's also worth pointing out that having seq_page_cost >
random_page_cost is simply not sane, and is very likely to result in
performance problems in other queries.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: How to speedup intarray aggregate function?
Next
From: Erik Jones
Date:
Subject: Re: Determine query run-time from pg_* tables