Re: [GENERAL] Large databases, performance

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [GENERAL] Large databases, performance
Date: 2002-10-08 14:41:47
Message-ID: 3DA33C03.31407.15BBAE9C@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance pgsql-sql

On 8 Oct 2002 at 10:38, Tom Lane wrote:

> Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> It's not simpler: it's more complicated, because you need an additional
> input item to figure out the size of any given column in a record.
> Making sure that that info is available every place it's needed is one
> of the costs of supporting a feature like this.

I understand. Can we put this in say page header instead of tuple header. While
all the arguments you have put are really good, the stellar redundancy
certainly can do with a mid-way solution.

Just a thought..

Bye
Shridhar

--
bit, n: A unit of measure applied to color. Twenty-four-bit color refers to
expensive $3 color as opposed to the cheaper 25 cent, or two-bit, color that
use to be available a few years ago.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2002-10-08 15:16:55 Re: [GENERAL] Large databases, performance
Previous Message Tom Lane 2002-10-08 14:38:02 Re: [GENERAL] Large databases, performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-08 14:50:58 Re: Dirty Buffer Writing [was Proposed LogWriter Scheme]
Previous Message Tom Lane 2002-10-08 14:41:43 Re: Analysis of ganged WAL writes

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2002-10-08 15:16:55 Re: [GENERAL] Large databases, performance
Previous Message Tom Lane 2002-10-08 14:38:02 Re: [GENERAL] Large databases, performance

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-10-08 15:00:15 Re: foreign key, on delete cascade...
Previous Message Tom Lane 2002-10-08 14:38:02 Re: [GENERAL] Large databases, performance