Postgres Pro
Downloads
Home   >   mailing lists

Re: About "Our CLUSTER implementation is pessimal" patch - Mailing list pgsql-hackers

From Leonardo F
Subject Re: About "Our CLUSTER implementation is pessimal" patch
Date
Msg-id 491989.57840.qm@web29017.mail.ird.yahoo.com
Whole thread Raw
In response to Re: About "Our CLUSTER implementation is pessimal" patch  (Leonardo F <m_lists@yahoo.it>)
Responses Re: About "Our CLUSTER implementation is pessimal" patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
So, if I'm not mistaken:


hash indexes -> can't be used in CLUSTER
gin indexes -> can't be used in CLUSTER

that leaves:

btree -> ok
expression btree -> I have to find a way to compute the expression for each tuple: hints?
gist -> how can I get something "comparable" by tuplesort? Or should I rule it  out from the seq scan + sort path?



Leonardo

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: warn in plperl logs as... NOTICE??
Next
From: Tom Lane
Date:
Subject: Re: restructuring "alter table" privilege checks (was: remove redundant ownership checks)