create table foo(a int primary key, b int, c int); insert into foo values (generate_series(1,10000), generate_series(1,10000), generate_series(1,10000)); create index concurrently on foo(b); create index concurrently on foo(c); vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) vacuum full foo; \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- a | integer | | not null | b | integer | | | c | integer | | | Indexes: "foo_pkey" PRIMARY KEY, btree (a) "foo_b_idx" btree (b) "foo_c_idx" btree (c) drop table foo;