Postgres Pro
Downloads
Home   >   mailing lists

Re: Clustered Index in PG - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Clustered Index in PG
Date
Msg-id 664c7f41d65dc6e4c92995260f0a8e50fc3c90af.camel@cybertec.at
Whole thread Raw
In response to Clustered Index in PG  (brajmohan saxena <braj.saxena.pg@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Peter
Date:
Subject: 12.2: Howto check memory-leak in worker?
Next
From: Justin King
Date:
Subject: Re: walreceiver termination