Re: Analysis Function - Mailing list pgsql-performance

From Tim Landscheidt
Subject Re: Analysis Function
Date
Msg-id m3eigdh03r.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to Re: Analysis Function  (David Jarvis <thangalin@gmail.com>)
List pgsql-performance
David Jarvis <thangalin@gmail.com> wrote:

> [...]
>> invest too much time to have the user wait not 4.4, but
>> 2.2 seconds. You could also do the concatenation in the ap-
>> plication if that is faster than PostgreSQL's date arithme-
>> tics.

> No, I cannot. The concatenation uses the year that the measurement was
> made--from the database--and the month/day combination from the user. See
> also:

> http://stackoverflow.com/questions/2947105/calculate-year-for-end-date-postgresql

That page doesn't deal with "select year from database and
month/day from user and present the results", but *much*
different problems.

Tim

pgsql-performance by date:

Previous
From: Bob Lunney
Date:
Subject: Re: Query about index usage
Next
From: Tom Lane
Date:
Subject: Re: Analysis Function