Postgres Pro
Downloads
Home   >   mailing lists

Thread: Clustered Index in PG

Clustered Index in PG

From
brajmohan saxena
Date:
Hi,

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

Braj
 

Re: Clustered Index in PG

From
Laurenz Albe
Date:
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.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com