Re: Analysis Function

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Analysis Function
Date: 2010-06-11 18:53:44
Message-ID: m3eigdh03r.fsf@passepartout.tim-landscheidt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

David Jarvis <thangalin(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-06-11 20:20:55 Re: Analysis Function
Previous Message Bob Lunney 2010-06-11 18:50:10 Re: Query about index usage