From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Most recent row |
Date: | 2017-05-05 11:09:39 |
Message-ID: | 20170505110939.GB20445@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-05-05 15:14:28 | Re: Most recent row |
Previous Message | Gary Stainburn | 2017-05-05 10:54:54 | Re: Most recent row |