Fastest way / best practice to calculate "next birthdays"

Поиск
Список
Период
Сортировка
От Hannes Dorbath
Тема Fastest way / best practice to calculate "next birthdays"
Дата
Msg-id fvka82$1b10$1@news.hub.org
обсуждение исходный текст
Ответы Re: Fastest way / best practice to calculate "next birthdays"
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Hannes Dorbath
Дата:
Сообщение: Re: pgPool query cache
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Fastest way / best practice to calculate "next birthdays"