agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: hubert depesz lubaczewski <depesz@depesz.com>
To: Gary Stainburn <gary.stainburn@ringways.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Most recent row
Date: Fri, 5 May 2017 13:09:39 +0200
Message-ID: <20170505110939.GB20445@depesz.com> (raw)
In-Reply-To: <201705051154.54863.gary.stainburn@ringways.co.uk>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
view thread (17+ messages) latest in thread
Message-ID: <20170505110939.GB20445@depesz.com>
Permalink: ../20170505110939.GB20445@depesz.com/
Also on: postgresql.org/message-id/20170505110939.GB20445@depesz.com
reply
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-sql@postgresql.org
Cc: depesz@depesz.com, gary.stainburn@ringways.co.uk
Subject: Re: Most recent row
In-Reply-To: <20170505110939.GB20445@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox