From: Gaetano Mendola <mendola@bigfoot.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Greg Spiegelberg <gspiegelberg@cranel.com>
Subject: Re: Compare rows
Date: Thu, 09 Oct 2003 20:32:21 +0200
Message-ID: <3F85A9B5.6030301@bigfoot.com> (raw)
In-Reply-To: <3F857E1C.1040209@cranel.com>
References: <3F841A28.8060504@cranel.com>
<200310081010.26576.josh@agliodbs.com>
<3F84613D.8040207@cranel.com>
<200310081611.59179.josh@agliodbs.com>
<3F857E1C.1040209@cranel.com>
Greg Spiegelberg wrote:
> Josh Berkus wrote:
>
>>
>> As you can see, the NULLs are not stored, making this system much more
>> efficient on storage space.
>>
>> Tommorrow I'll (hopefully) write up how to query this for
>> comparisons. It would help if you gave a little more details about
>> what specific comparison you're doing, e.g. between tables or table to
>> value, comparing just the last value or all rows, etc.
>>
>
> Got it. I can see how it would be more efficient in storing. At this
> point it would require a lot of query and code rewrites to handle it.
> Fortunately, we're looking for alternatives for the next revision and
> we're leaving ourselves open for a rewrite much to the boss's chagrin.
I'm not sure about the save in storage. See the Hannu Krosing
arguments.
Regards
Gaetano Mendola
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: mendola@bigfoot.com, gspiegelberg@cranel.com
Subject: Re: Compare rows
In-Reply-To: <3F85A9B5.6030301@bigfoot.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