>
> Partition key: LIST (date_part('year'::text, mis_ora))
>
As an aside, you may benefit from switching to range partitioning*
depending on how your queries are written. If you have conditions such as
"WHERE mis_ora BETWEEN CURRENT_DATE - 30 AND CURRENT_DATE" or similar, then
the fact that your p
On Mon, Sep 23, 2019 at 2:23 PM Ron wrote:
> Try specifying the schema name:
Yeah, shame on me, I always forget the schema for indexes!
Thanks,
Luca
On 9/23/19 6:39 AM, Luca Ferrari wrote:
Hi,
running 11.5 I've got a partitioned table where I want to destroy an
index (on a column that has nothing to do with the partition):
respidb=# \d+ respi.root
Column|Type |
--+-+-
Hi,
running 11.5 I've got a partitioned table where I want to destroy an
index (on a column that has nothing to do with the partition):
respidb=# \d+ respi.root
Column|Type |
--+-+-
sen_id | integer
