Re: 7.2.1 optimises very badly against 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: Sam Liddicott <sam(dot)liddicott(at)ananova(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2.1 optimises very badly against 7.2
Date: 2002-07-12 15:35:36
Message-ID: 10094.1026488136@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jean-Luc Lachance <jllachan(at)nsd(dot)ca> writes:
> Is the number of record per page and the number of key per page taken in
> consideration?

Yes, indirectly. (The cost equations actually use total tuples and
total pages in each table/index, but that's isomorphic to using average
tuple size or average number of tuples per page or however you want
to think about it ...)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Ince 2002-07-12 15:40:30 ODBC Error while selecting a numeric data field
Previous Message Joo Paulo Batistella 2002-07-12 15:31:46 Free Hosting - Postgres