From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: PFC <lists@boutiquenumerique.com>
Cc: Steve Wampler <swampler@noao.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Make COUNT(*) Faster?
Date: Fri, 8 Jul 2005 15:51:25 -0400
Message-ID: <20050708195125.GI1915@alvh.no-ip.org> (raw)
In-Reply-To: <op.stlq3pkwth1vuj@localhost>
References: <9EF2931D-1097-470D-8ECB-59D00166C96F@apple.com>
<60vf3mklue.fsf@dba2.int.libertyrms.com>
<42CE89CA.2070607@noao.edu>
<20050708143508.GD22725@wolff.to>
<42CE96AF.3020903@noao.edu>
<22916.1120836900@sss.pgh.pa.us>
<42CEA305.1050904@noao.edu>
<op.stlq3pkwth1vuj@localhost>
On Fri, Jul 08, 2005 at 06:08:03PM +0200, PFC wrote:
>
>
> >which wouldn't have helped.) If true, I can handle that parsing myself
> >easily enough without exposing RelationGetNumberOfBlocks.
>
> Is there a way to get EXPLAIN results in a non-text-formatted way
> for easier use ?
> I'm asking, because it seems the feature set grows by the minute in
> posgres nowadays...
Not yet, but a friend of mine was working on a patch to make it output
in a custom XML format, to be able to create a tool similar to Redhat's
Visual Explain. I expect he will show up in pgsql-hackers sometime ...
In spanish: http://www.ubiobio.cl/~gpoo/weblog/archives/000397.html
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)
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-sql@postgresql.org
Cc: alvherre@alvh.no-ip.org, lists@boutiquenumerique.com, swampler@noao.edu
Subject: Re: Make COUNT(*) Faster?
In-Reply-To: <20050708195125.GI1915@alvh.no-ip.org>
* 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