Postgres Pro
Downloads
Home   >   mailing lists

Re: Declarative partitioning - Mailing list pgsql-hackers

From Ildar Musin
Subject Re: Declarative partitioning
Date
Msg-id 5739C742.80504@postgrespro.ru
Whole thread Raw
In response to Re: Declarative partitioning  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: Declarative partitioning  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
Tree view 
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.musin@postgrespro.ru

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Backup doc typo
Next
From: Nikolay Shaplov
Date:
Subject: [PATCH][Documination] Add optional USING keyword before opclass name in INSERT statemet