Re: Gsoc2012 idea, tablesample - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Gsoc2012 idea, tablesample
Date
Msg-id 4FAD030C0200002500047BF1@gw.wicourts.gov
Whole thread Raw
In response to Re: Gsoc2012 idea, tablesample  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Gsoc2012 idea, tablesample
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, May 11, 2012 at 11:36 AM, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
>> Robert Haas <robertmhaas@gmail.com> wrote:
>>> The trouble is, AFAICS, that you can't bound M very well without
>>> scanning the whole table.  I mean, it's bounded by theoretical
>>> limit, but that's it.
>>
>> What would the theoretical limit be?
> 
> MaxHeapTuplesPerPage?
What about dead line pointers without corresponding tuples?
-Kevin


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: PL/perl elog(ERROR) Does not Abort Transaction
Next
From: Tom Lane
Date:
Subject: Re: PL/perl elog(ERROR) Does not Abort Transaction