Re: Clustered Index in PG

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: brajmohan saxena <braj(dot)saxena(dot)pg(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Clustered Index in PG
Date: 2020-05-04 12:08:11
Message-ID: 664c7f41d65dc6e4c92995260f0a8e50fc3c90af.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin King 2020-05-04 14:09:15 Re: walreceiver termination
Previous Message Peter 2020-05-04 11:56:49 12.2: Howto check memory-leak in worker?