Cluster and index without a cluster in PostgreSQL

I am using PostgreSQL version 9.3 to create a database.

I have the following table test with some column lists.

create table test
(
  cola varchar(10),
  colb varchar(10),
  colc varchar(10),
  cold varchar(10)
);

Now I want to create indexes for some columns.

For instance:

I want to create a clustered index for colaand columns colb.

And I want to create a non-clustered index for colcand columns cold.

As I called this and this , I found out that there is no clustered and non-clustered index in PostgreSQL.

My question is . What type of index can I use instead of a clustered and non-clustered index in PostgreSQL that does the same job as clustered and non-clustered indexes?

+3
1

Source: https://habr.com/ru/post/1690316/


All Articles