Re: 7.2.1 optimises very badly against 7.2

Just curious,

Is the number of record per page and the number of key per page taken in
consideration?


Tom Lane wrote:
>
> "Sam Liddicott" <sam.liddicott@ananova.com> writes:
> > Do you feel the random page cost of 3 is good to solve this?
>
> For the moment, anyway.  There have been a couple of rounds of
> pgsql-hackers discussion about whether to lower the default value of
> random_page_cost, but so far no one has done any experiments that
> would be needed to establish a good new value.  (The current default
> of 4.0 is based on some old experiments I did.  I'm quite willing to
> accept that those experiments might have been flawed, but not willing
> to replace the number without seeing better experiments...)
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster