[GENERAL] hint unique result fro union

[Matteo Bertini]

Hello all!

I'm quite new to pg, but I'm using it quite a lot in the last few monts.

Deeping in new features, I found a question: is it possible to hint an unique result from a select?

Mainly, thinking about partitions, I'd like to create a small, frequently accessed partition and a big, rarely accessed partition.

I'd like to hint pg to stop the query on the parent partition at the first found item (and so hint not to analyze all the childs), because I know the index I'm using is unique.

Possible? Usefull?

Thanks,
Matteo Bertini