Re: Declarative partitioning

From: Ildar Musin <i(dot)musin(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Declarative partitioning
Date: 2016-05-16 13:12:34
Message-ID: 5739C742.80504@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Amit,

I'm running some experiments based on your infrastructure trying to
optimize SELECT queries. At some point I need to get PartitionDesc for
relation and to do it I'm using RelationGetPartitionDesc() function.
Problem is that this function copies relcache data and it can be quite
slow for large amounts (thousands) of partitions. The comment to the
function says that we cannot use relation->rd_partdesc pointer to
relcache because of possibility of relcache invalidation. Could you
please tell is it possible that relcache invalidation occurs during
SELECT/UPDATE/DELETE query?

Thanks!

--
Ildar Musin
i(dot)musin(at)postgrespro(dot)ru

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikolay Shaplov 2016-05-16 13:21:10 [PATCH][Documination] Add optional USING keyword before opclass name in INSERT statemet
Previous Message Amit Langote 2016-05-16 10:08:11 Backup doc typo