RE: scans on table fail to be excluded by partition bounds

Поиск
Список
Период
Сортировка
От Steven Winfield
Тема RE: scans on table fail to be excluded by partition bounds
Дата
Msg-id E9FA92C2921F31408041863B74EE4C2001BD7B6764@CCPMAILDAG03.cantab.local
обсуждение исходный текст
Ответ на scans on table fail to be excluded by partition bounds  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: scans on table fail to be excluded by partition bounds
Список pgsql-performance
> ts=# explain SELECT * FROM eric_enodeb_cell_metrics WHERE start_time
> BETWEEN '2019-01-01 04:00' AND '2019-01-01 05:00' OR start_time BETWEEN
> '2019-01-02 04:00' AND '2019-01-02 05:00'

Maybe it's because of the implicit usage of the local timezone when the strings are cast to (timestamp with time zone)
inthe values you give for start_time here? 
What happens if you specify it using "TIMESTAMP WITH TIME ZONE '2019-01-01 04:00-05'", etc.?

Steve.




В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: scans on table fail to be excluded by partition bounds
Следующее
От: Rick Otten
Дата:
Сообщение: Re: materialized view refresh of a foreign table