From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Arseny Sher <a(dot)sher(at)postgrespro(dot)ru> |
Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Indexes on partitioned tables and foreign partitions |
Date: | 2018-05-09 14:45:13 |
Message-ID: | CANP8+jJLyg1zMJ9iUXi0_A-CBOYpEztY_QV=DM1xNR6mfM+MOw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 9 May 2018 at 15:26, Arseny Sher <a(dot)sher(at)postgrespro(dot)ru> wrote:
>
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
>
>> How much sense is it to have a partitioned table with a mix of local
>> and foreign tables?
>
> Well, as much sense as fdw-based sharding has, for instance. It is
> arguable, but it exists.
>
>> Shouldn't the fix be to allow creation of indexes on foreign tables?
>> (Maybe they would be virtual or foreign indexes??)
>
> Similar ideas were discussed at [1]. There was no wide consensus of even
> what problems such feature would solve. Since currently indexes on
> foreign tables are just forbidden, it seems to me that the best what
> partitioning code can do today is just not creating them.
>
> [1] https://www.postgresql.org/message-id/flat/4F62FD69(dot)2060007%40lab(dot)ntt(dot)co(dot)jp#4F62FD69(dot)2060007(at)lab(dot)ntt(dot)co(dot)jp
Indexes on foreign tables cause an ERROR, so yes, we already just
don't create them.
You're suggesting silently skipping the ERROR. I can't see a reason for that.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2018-05-09 14:51:25 | Re: Global snapshots |
Previous Message | Alvaro Herrera | 2018-05-09 14:30:53 | Re: [HACKERS] path toward faster partition pruning |