Skip site navigation (1) Skip section navigation (2)

Re: Please advise features in 7.1 (SUMMARY)

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Zeugswetter Andreas SB" <ZeugswetterA(at)wien(dot)spardat(dot)at>, "'Ross J(dot) Reedstrom'" <reedstrm(at)rice(dot)edu>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Please advise features in 7.1 (SUMMARY)
Date: 2000-11-28 17:05:29
Message-ID: 007401c0595d$6979bb70$0200000a@windows (view raw or flat)
Thread:
Lists: pgsql-hackers
I guess it depends on what you're using it for -- disk space is cheap and
abundant anymore, I can see some advantages of having it computed only once
rather than X times, where X is the number of SELECTs as that could get
costly on really high traffic servers.. Costly not so much for simple
computations like that but more complex ones.

Just playing the devil's advocate a bit.

-Mitch

----- Original Message -----
From: "Zeugswetter Andreas SB" <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Ross J. Reedstrom'" <reedstrm(at)rice(dot)edu>;
<pgsql-hackers(at)postgresql(dot)org>
Sent: Tuesday, November 28, 2000 7:50 AM
Subject: AW: [HACKERS] Please advise features in 7.1 (SUMMARY)


>
> > > This is a summary of replies.
> > >
> > > 1. Calculated fields in table definitions . eg.
> > >
> > >     Create table test (
> > >              A Integer,
> > >              B integer,
> > >             the_sum   As  (A+B),
> > > );
> > >
> > > This functionality can be achieved through the use of views.
> >
> > Using a view for this isn't quite the same functionality as a computed
> > field, from what I understand, since the calculation will be done at
> > SELECT time, rather than INSERT/UPDATE.
>
> I would expect the calculated field from above example to be calculated
> during select time also, no ? You don't want to waste disk space with
something
> you can easily compute at runtime.
>
> Andreas
>


In response to

pgsql-hackers by date

Next:From: Zeugswetter Andreas SBDate: 2000-11-28 17:11:53
Subject: AW: Please advise features in 7.1 (SUMMARY)
Previous:From: Ross J. ReedstromDate: 2000-11-28 16:54:54
Subject: Re: Please advise features in 7.1 (SUMMARY)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group