There is a thing that might lead to confusion in the previous post:
> create or replace function yearmod(int) RETURNS int
> as 'select (($1 >> 2) %32);'
> language sql
is equivalent with
create or replace function yearmod(int) RETURNS int
as 'select (($1 / 4) %32);'
and that is the function that was used with all the other output (it can
be seen inlined in the explain output). I did not catch this until after
In response to
pgsql-performance by date
|Next:||From: venu madhav||Date: 2010-05-21 09:38:43|
|Subject: Autovacuum in postgres.|
|Previous:||From: Yeb Havinga||Date: 2010-05-21 08:38:43|
|Subject: Re: Optimize date query for large child tables: GiST or