agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
To: 'Amit Kapila' <amit.kapila16@gmail.com>
Cc: 'Robert Haas' <robertmhaas@gmail.com>
Cc: 'Andres Freund' <andres@2ndquadrant.com>
Cc: 'Alvaro Herrera' <alvherre@2ndquadrant.com>
Cc: 'Bruce Momjian' <bruce@momjian.us>
Cc: 'Pg Hackers' <pgsql-hackers@postgresql.org>
Subject: Re: On partitioning
Date: Fri, 5 Dec 2014 13:22:13 -0600
Message-ID: <548205E5.7020505@BlueTreble.com> (raw)
In-Reply-To: <029e01d0106f$d511eb40$7f35c1c0$@lab.ntt.co.jp>
References: <20140829155607.GF7705@eldon.alvh.no-ip.org>
<20141028100629.GE2639@awork2.anarazel.de>
<CA+TgmoaHPXfStSk2QERkWkWPnc63HRDgn=+9Nwt+HTd-=dUv+Q@mail.gmail.com>
<053501cffa30$ecdf8700$c69e9500$@lab.ntt.co.jp>
<CA+TgmobN+DT_=hj3NkXZgSv157-W24YaZ50oFdRbhS493covzg@mail.gmail.com>
<066501cffd52$3d919390$b8b4bab0$@lab.ntt.co.jp>
<CA+TgmoZqndQQQY1U0OBxUOJy1RE_MAawJErghNB7RM8MPgCYDg@mail.gmail.com>
<032601d00471$ea6f4280$bf4dc780$@lab.ntt.co.jp>
<CA+TgmoZ-HJOTPfZcnPOh27881xn4N1QGtY7J4nG+v6tV9cJjNw@mail.gmail.com>
<04da01d00917$2dde1010$899a3030$@lab.ntt.co.jp>
<CA+TgmoaU+0EN-XsAT1O+64xrENNJiKPgem+Q1hWzz7a=1MYrDA@mail.gmail.com>
<015b01d00eab$56d37700$047a6500$@lab.ntt.co.jp>
<0! 1ca01d00f81$74f2c750$5e d855f0$@lab.ntt.co.jp>
<CAA4eK1+pJaZGHBeSxKtUd_gNeGjUDMrftmwjGC+PBob-ZFNk-Q@mail.gmail.com>
<028401d01058$b4b19dd0$1e14d970$@lab.ntt.co.jp>
<CAA4eK1K=_DxN-ALbDx-u6P=GOr94W04vOJu4qsExNLsKJoBx9g@mail.gmail.com>
<029e01d0106f$d511eb40$7f35c1c0$@lab.ntt.co.jp>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 12/5/14, 3:42 AM, Amit Langote wrote:
>> > I think you are right. I think in this case we need something similar
>> >to column pg_index.indexprs which is of type pg_node_tree(which
>> >seems to be already suggested by Robert). So may be we can proceed
>> >with this type and see if any one else has better idea.
> One point raised about/against pg_node_tree was the values represented therein would turn out to be too generalized to be used with advantage during planning. But, it seems we could deserialize it in advance back to the internal form (like an array of a struct) as part of the cached relation data. This overhead would only be incurred in case of partitioned tables. Perhaps this is what Robert suggested elsewhere.
In order to store a composite type in a catalog, we would need to have one field that has the typid of the composite, and the field that stores the actual composite data would need to be a "dumb" varlena that stores the composite HeapTupleHeader.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
view thread (170+ messages) latest in thread
Message-ID: <548205E5.7020505@BlueTreble.com>
Permalink: ../../548205E5.7020505@BlueTreble.com/
Also on: postgresql.org/message-id/548205E5.7020505@BlueTreble.com
reply
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: Jim.Nasby@BlueTreble.com, Langote_Amit_f8@lab.ntt.co.jp, amit.kapila16@gmail.com, robertmhaas@gmail.com, andres@2ndquadrant.com, alvherre@2ndquadrant.com, bruce@momjian.us
Subject: Re: On partitioning
In-Reply-To: <548205E5.7020505@BlueTreble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox