Re: Gsoc2012 idea, tablesample

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Gsoc2012 idea, tablesample
Дата
Msg-id 4FAD030C0200002500047BF1@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Gsoc2012 idea, tablesample  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Gsoc2012 idea, tablesample  (Greg Stark <stark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: PL/perl elog(ERROR) Does not Abort Transaction
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PL/perl elog(ERROR) Does not Abort Transaction