Yes, the "LIMIT 1" is OK, thanks!I didn't noticed the "not executed" in the explain output!I have done some test comparing a plain table and a partitioned table performance in a particular statistical hypothesis (something explained here too:
http://tagschema.com ).Mainly, data is produced and ask
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
On Aug 16, 2006, at 8:23 AM, Matteo Bertini wrote:
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 crea
