Re: Optimize date query for large child tables: GiST or GIN? - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: Optimize date query for large child tables: GiST or GIN?
Date
Msg-id 4BF64830.4080902@gmail.com
Whole thread Raw
In response to Re: Optimize date query for large child tables: GiST or GIN?  (Yeb Havinga <yebhavinga@gmail.com>)
Responses Re: Optimize date query for large child tables: GiST or GIN?
List pgsql-performance
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
> immutable
> strict;
is equivalent with

create or replace function yearmod(int) RETURNS int
as 'select (($1 / 4) %32);'
language sql
immutable
strict;

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
the post.

regards,
Yeb Havinga



pgsql-performance by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: Optimize date query for large child tables: GiST or GIN?
Next
From: Piotr Legiecki
Date:
Subject: Re: old server, new server, same performance