From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org
Subject: Re: WIP: multivariate statistics / proof of concept
Date: Fri, 20 Mar 2015 22:17:04 +0100
Message-ID: <550C8E50.2010600@2ndquadrant.com> (raw)
In-Reply-To: <20150320.173307.249113775.horiguchi.kyotaro@lab.ntt.co.jp>
References: <CAB7nPqQhM9meSoN7JD+JdFutyXmvcGSN8vptVB79qWTZAqLgWw@mail.gmail.com>
<CAB7nPqSx1eS55b4WeoRxcCOKKVZFd3e-midUciH02UpJSnjT3Q@mail.gmail.com>
<54C3FED3.1060600@2ndquadrant.com>
<20150320.173307.249113775.horiguchi.kyotaro@lab.ntt.co.jp>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Hello,
On 20.3.2015 09:33, Kyotaro HORIGUCHI wrote:
> Hello,
>
>
> Patch 0001 needs changes for OIDs since my patch was
> committed. The attached is compatible with current master.
Thanks. I plan to submit a new version of the patch in a few days, with
significant progress in various directions. I'll have to rebase to
current master before submitting the new version anyway (which includes
fixing duplicate OIDs).
> And I tried this like this, and got the following error on
> analyze. But unfortunately I don't have enough time to
> investigate it now.
>
> postgres=# create table t1 (a int, b int, c int);
> insert into t1 (select a/ 10000, a / 10000, a / 10000 from
> generate_series(0, 99999) a);
> postgres=# analyze t1;
> ERROR: invalid memory alloc request size 1485176862
Interesting - particularly because this does not involve any
multivariate stats. I can't reproduce it with the current version of the
patch, so either it's unrelated, or I've fixed it since posting the last
version.
regards
--
Tomas Vondra http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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-hackers@postgresql.org
Cc: tomas.vondra@2ndquadrant.com, horiguchi.kyotaro@lab.ntt.co.jp
Subject: Re: WIP: multivariate statistics / proof of concept
In-Reply-To: <550C8E50.2010600@2ndquadrant.com>
* 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