Re: group by week (ww), plus -S performance - Mailing list pgsql-general

From Erich
Subject Re: group by week (ww), plus -S performance
Date
Msg-id 200005290639.XAA13934@cyberpass.net
Whole thread Raw
In response to Re: group by week (ww), plus -S performance  (Michael Blakeley <mike@blakeley.com>)
List pgsql-general
> Thanks - that seems to be about 10% faster. I also got a 25% boost
> by recompiling PG7 with -O3.

Do you mean you got a 25% boost by recompiling with -O3 instead of
-O2, or instead of -g?  If going from -O2 to -O3 gives a 25% boost,
time for me to recompile.  I'm just now moving from MySQL to
PostgreSQL, and I'm also totally changing the data structures into
something much less efficient, so I need all the speed boosts I can
get.  Recompiling is much cheaper than buying a new computer.

e

pgsql-general by date:

Previous
From: Michael Blakeley
Date:
Subject: Re: group by week (ww), plus -S performance
Next
From: "Stuart Grimshaw"
Date:
Subject: ODBC