Clustered Index in PG

Started by brajmohan saxenaalmost 6 years ago2 messagesgeneral

braj.saxena.pg@gmail.com

almost 6 years ago

Hi,

Is there cluster index in PG ? Do we have Indexed Organized Table concepts
of Oracle in PG ?

Braj

laurenz.albe@cybertec.at

almost 6 years ago

In reply to: brajmohan saxena (#1)

Re: Clustered Index in PG

On Sun, 2020-05-03 at 16:55 +0530, brajmohan saxena wrote:

Is there cluster index in PG ? Do we have Indexed Organized Table concepts of Oracle in PG ?

No.

You can use CLUSTER to rewrite a table in index order, but the order won't be maintained.