alter index WITH ( storage_parameter = value [, ... ] ) for partition index.

Поиск
Список
Период
Сортировка
От Rajkumar Raghuwanshi
Тема alter index WITH ( storage_parameter = value [, ... ] ) for partition index.
Дата
Msg-id CAKcux6mb6AZjMVyohnta6M+fdkUB720Gq8Wb6KPZ24FPDs7qzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: alter index WITH ( storage_parameter = value [, ... ] ) forpartition index.  (Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>)
Re: alter index WITH ( storage_parameter = value [, ... ] ) forpartition index.  (Robert Haas <robertmhaas@gmail.com>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Portability concerns over pq_sendbyte?
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: WAL prefetch