Re: 7.2.1 optimises very badly against 7.2 - Mailing list pgsql-general

From Jean-Luc Lachance
Subject Re: 7.2.1 optimises very badly against 7.2
Date
Msg-id 3D2EEB79.F20AD831@nsd.ca
Whole thread Raw
In response to Re: 7.2.1 optimises very badly against 7.2  ("Sam Liddicott" <sam.liddicott@ananova.com>)
Responses Re: 7.2.1 optimises very badly against 7.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: [SQL] Please, HELP! Why is the query plan so wrong???
Next
From: Thomas Lockhart
Date:
Subject: Re: workaround for lack of REPLACE() function