Rauan Maemirov wrote:
I want to ask, if anyone used query_cache of pgPool. The problem is
there is no detailed installation steps on how to configure it
correctly. Itried to follow it, but guess that it doesn't cache my
queries. So, maybe someone adviced me or give link.
Nobody use??
I'd say
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 headac
Hannes Dorbath wrote:
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
Joshua D. Drake wrote:
postgres=# SELECT current_date|| ' a ' || to_char(current_date, 'Day'),
current_date + '1 Year'::interval || ' a ' || to_char(current_date + '1
Year'::interval, 'Day') as next_birthday;
?column?| next_birthday
+---
Hannes Dorbath írta:
Joshua D. Drake wrote:
postgres=# SELECT current_date|| ' a ' || to_char(current_date, 'Day'),
current_date + '1 Year'::interval || ' a ' || to_char(current_date +
'1 Year'::interval, 'Day') as next_birthday;
?column?| next_birthday
--
Hannes Dorbath wrote:
Sorry, I think I phrased the question badly. What I'm after basically is:
http://www.depesz.com/index.php/2007/10/26/who-has-birthday-tomorrow/
OK So what I came up with is - (the times are from a G4 1.25Ghz)
CREATE TABLE birthdaytest
(
id serial PRIMARY KEY,
birth
