Date: Fri, 5 May 2017 13:09:39 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Gary Stainburn <gary.stainburn@ringways.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Most recent row
Message-ID: <20170505110939.GB20445@depesz.com>
Reply-To: depesz@depesz.com
References: <201705050925.04194.gary.stainburn@ringways.co.uk>
 <201705051044.54259.gary.stainburn@ringways.co.uk>
 <20170505100037.GA23734@depesz.com>
 <201705051154.54863.gary.stainburn@ringways.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <201705051154.54863.gary.stainburn@ringways.co.uk>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On Fri, May 05, 2017 at 11:54:54AM +0100, Gary Stainburn wrote:
> On Friday 05 May 2017 11:00:37 hubert depesz lubaczewski wrote:
> > On Fri, May 05, 2017 at 10:44:54AM +0100, Gary Stainburn wrote:
> > > > How many rows are in people? How many in assessments? Do you really
> > > > want data on all people? Or just some?
> > >
> > > I was looking for a balanced solution, combining performance and SQL
> > > 'purity'.
> >
> > Solution depends on answers to questions I asked. Will you always get
> > data for all people? Or just some? How many assessments per person will
> > there usually be?
> >
> > Best regards,
> >
> > depesz
> 
> Oddly, part of my reply was missing.
> 
> As I said, there are currently 720 rows in the people table.  
> The will be a new assessment record for each person roughly every six months.
> The dataset will be open ended so will slowly but indefinitely grow.
> 
> The part that was missing was that there will be new people records added who 
> initially will not have an assessment. They will still need to be included in 
> the report.

There was this part, but it still doesn't contain information about:
- how many assessments per person will there usually be?
- will you always get data for all people?
- if not (all people) - how many (percent or count)?

Best regards,

depesz


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql