Postgres Pro
Downloads
Home   >   mailing lists

Fastest way / best practice to calculate "next birthdays" - Mailing list pgsql-performance

From Hannes Dorbath
Subject Fastest way / best practice to calculate "next birthdays"
Date
Msg-id fvka82$1b10$1@news.hub.org
Whole thread Raw
Responses Re: Fastest way / best practice to calculate "next birthdays"
List pgsql-performance
Tree view 
The subject basically says it all, I'm looking for the fastest
(indexable) way to calculate the next birthdays relative to NOW() from a
dataset of about 1 million users.

I'm currently using a function based index, but leap year handling /
mapping February 29 to February 28 gives me some headaches.

Is there any best practice to do that in PostgreSQL?


--
Best regards,
Hannes Dorbath

pgsql-performance by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: pgPool query cache
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Fastest way / best practice to calculate "next birthdays"