Re: Optimize date query for large child tables: GiST or GIN?

Поиск
Список
Период
Сортировка
От Yeb Havinga
Тема Re: Optimize date query for large child tables: GiST or GIN?
Дата
Msg-id 4BF64830.4080902@gmail.com
обсуждение исходный текст
Ответ на Re: Optimize date query for large child tables: GiST or GIN?  (Yeb Havinga <yebhavinga@gmail.com>)
Ответы Re: Optimize date query for large child tables: GiST or GIN?  (David Jarvis <thangalin@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: Optimize date query for large child tables: GiST or GIN?
Следующее
От: Piotr Legiecki
Дата:
Сообщение: Re: old server, new server, same performance