On Mon, Jan 16, 2012 at 4:08 PM, Tomas Vondra <tv@xxxxxxxx> wrote:
Yeah, that works, but it's kinda impractical... I'm mostly trying to figure out how fragmented a table is,
by checking how must the blocks are shared - so that the worst one can be scheduled for clustering...
The only other solution is to check all possible items on the page. There
may be up to 291 items (although it depends on block size and
architecture, see MaxHeapTuplesPerPage in access/htup.h).
Nice to know.
Something like this should work
ctid = '(123,0)'::tid OR ctid = '(123,1)'::tid OR ctid = '(123,2)'::tid
OR ... OR ctid = '(123,290)'::tid
Yeah, that works, but it's kinda impractical... I'm mostly trying to figure out how fragmented a table is,
by checking how must the blocks are shared - so that the worst one can be scheduled for clustering...
But maybe someone will recommend a better solution.
Hopefully - thanks anyway :)
--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2012 Tore Halvorsen || +052 0553034554
