Clustered Index in PG

Started by brajmohan saxenaalmost 6 years ago2 messagesgeneral
Jump to latest
#1brajmohan saxena
braj.saxena.pg@gmail.com

Hi,

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

Braj

#2Laurenz Albe
laurenz.albe@cybertec.at
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.

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