my (small) experience this trick can speeds-up a lot of queries of
this kind.
Bye,
Matteo Bertini
---(end of broadcast)---
TIP 6: explain analyze is your friend
d 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
Correct! Didn't noticed the "never executed" in the explain analyze
output :-P
Steve Atkins ha scritto:
>
>
> "select foo from bar limit 1" ?
>
> I don't know if there's any guaranteed ordering of results from
> a union query, though, and that's what a query on a set of
> inherited tables will exp
lish, and open to comment about my simple benchmark,
Matteo Bertini2006/8/16, Steve Atkins <[EMAIL PROTECTED]>:
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 ne
