From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Kris Jurka <books@ejurka.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: No hash join across partitioned tables?
Date: Sat, 16 Oct 2010 01:22:42 -0400
Message-ID: <29559.1287206562@sss.pgh.pa.us> (raw)
In-Reply-To: <1287205016-sup-542@alvh.no-ip.org>
References: <201002252346.o1PNkXG07892@momjian.us>
<9477.1267142614@sss.pgh.pa.us>
<603c8f071003020816j77b3ec63wbad0415df003c0f1@mail.gmail.com>
<17546.1267546998@sss.pgh.pa.us>
<AANLkTinx8lLTEKWcyEQ1rxVz6WMJVKNezfXW5TKnNAU6@mail.gmail.com>
<1287205016-sup-542@alvh.no-ip.org>
Alvaro Herrera <alvherre@commandprompt.com> writes:
> If we analyze the parent, do we also update the children stats, or is it
> just that we keep two stats for the parent, one with children and one
> without, both being updated when the parent is analyzed?
The latter.
The trick here is that we need to fire an analyze on the parent even
though only its children may have had any updates.
> If the latter's the case, maybe we should modify ANALYZE a bit more, so
> that we can analyze the whole hierarchy in one go, and store the lot of
> stats with a single pass (each child alone, the parent alone, the parent
> plus children). However it's not real clear how would this work with
> multiple inheritance levels.
It's also not clear how it works without blowing out memory...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, alvherre@commandprompt.com, robertmhaas@gmail.com, bruce@momjian.us, books@ejurka.com
Subject: Re: No hash join across partitioned tables?
In-Reply-To: <29559.1287206562@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox