Re: Compare rows - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: Compare rows
Date
Msg-id 3F85A9B5.6030301@bigfoot.com
Whole thread Raw
In response to Re: Compare rows  (Greg Spiegelberg <gspiegelberg@cranel.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: David Griffiths
Date:
Subject: Re: OFFTOPIC: PostgreSQL vs MySQL
Next
From: Greg Stark
Date:
Subject: Re: Speeding up Aggregates