From: | Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | alter index WITH ( storage_parameter = value [, ... ] ) for partition index. |
Date: | 2018-06-27 09:42:14 |
Message-ID: | CAKcux6mb6AZjMVyohnta6M+fdkUB720Gq8Wb6KPZ24FPDs7qzg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I have created partition table index with some storage_parameter like
example given below, I am not able to reset/modify it from partition table.
Is this fine.
postgres=# create table part(a int) PARTITION BY RANGE(a);
CREATE TABLE
postgres=# create table part_p partition of part for values from (minvalue)
to (maxvalue);
CREATE TABLE
postgres=# create index part_idx on part(a) with (fillfactor = '14');
CREATE INDEX
postgres=# \d part
Table "public.part"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
a | integer | | |
Partition key: RANGE (a)
Indexes:
"part_idx" btree (a) WITH (fillfactor='14')
Number of partitions: 1 (Use \d+ to list them.)
postgres=# \d part_p
Table "public.part_p"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
a | integer | | |
Partition of: part FOR VALUES FROM (MINVALUE) TO (MAXVALUE)
Indexes:
"part_p_a_idx" btree (a) WITH (fillfactor='14')
*postgres=# alter index part_idx reset (fillfactor);ERROR: "part_idx" is
not a table, view, materialized view, or index*
postgres=# alter index part_p_a_idx reset (fillfactor);
ALTER INDEX
postgres=# \d+ part
Table "public.part"
Column | Type | Collation | Nullable | Default | Storage | Stats target
| Description
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain |
|
Partition key: RANGE (a)
Indexes:
* "part_idx" btree (a) WITH (fillfactor='14')*
Partitions: part_p FOR VALUES FROM (MINVALUE) TO (MAXVALUE)
postgres=# \d part_p
Table "public.part_p"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
a | integer | | |
Partition of: part FOR VALUES FROM (MINVALUE) TO (MAXVALUE)
Indexes:
"part_p_a_idx" btree (a)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
From | Date | Subject | |
---|---|---|---|
Next Message | ERR ORR | 2018-06-27 09:44:02 | Re: Code of Conduct committee: call for volunteers |
Previous Message | Michael Paquier | 2018-06-27 09:40:46 | Re: Portability concerns over pq_sendbyte? |