From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: AJ Weber <aweber@comcast.net>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Partition table in 9.0.x?
Date: Tue, 08 Jan 2013 12:51:40 -0500
Message-ID: <10931.1357667500@sss.pgh.pa.us> (raw)
In-Reply-To: <CAMkU=1yNdVOi54yLpWCWF7a81X5XbF01=fukJT0xp_eACKTubA@mail.gmail.com>
References: <CALd8TVECZDosPDZ7Cwv1gVRy1p2F4Hg+sw+240MsN36KUkt31g@mail.gmail.com>
<50E65B85.9000001@synedra.com>
<50E74A33.5000204@comcast.net>
<CAMkU=1yMkZtme3pB=J8=LrzmqtRDMhOU6mMp1KZAX_VTsdKTbA@mail.gmail.com>
<50E997C5.2000301@comcast.net>
<CAMkU=1waDCS4d6M1SeRDZq3JP6V7_Mf2PL2di_V4UwyfJYybiw@mail.gmail.com>
<50EC4D3D.9060209@comcast.net>
<CAMkU=1yNdVOi54yLpWCWF7a81X5XbF01=fukJT0xp_eACKTubA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Jeff Janes <jeff.janes@gmail.com> writes:
> On Tue, Jan 8, 2013 at 8:45 AM, AJ Weber <aweber@comcast.net> wrote:
>>
>> \d+ doesn't appear to display any size information.
> It does if you use it without an argument, to display all the tables
> in the search path:
> jjanes=# \d+
> List of relations
> Schema | Name | Type | Owner | Size | Description
> --------+------------------+-------+--------+---------+-------------
> public | pgbench_accounts | table | jjanes | 128 MB |
> public | pgbench_branches | table | jjanes | 40 kB |
> public | pgbench_history | table | jjanes | 0 bytes |
> public | pgbench_tellers | table | jjanes | 40 kB |
> (4 rows)
> It rather annoys me that you actually get less information (no size,
> no owner) when you use \d+ on a named table. I don't know if there is
> a reason for that feature, or if it was just an oversight.
This is actually an abbreviation for \dtisv+, which is a completely
different command from "\d table". You can use something like
"\dt+ table-pattern" to get a display of the above form for a subset
of tables. I agree it ain't too consistent.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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, jeff.janes@gmail.com, aweber@comcast.net
Subject: Re: Partition table in 9.0.x?
In-Reply-To: <10931.1357667500@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