Re: [GENERAL] Question about paritioning

Поиск
Список
Период
Сортировка
От Alex Samad
Тема Re: [GENERAL] Question about paritioning
Дата
Msg-id CAJ+Q1PX2R4GEDZW+64XWW48odvv2WYtPH3JPL=p789ead3T7Mw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Question about paritioning  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
so I have a pgsql function that will create tables based on YYYYMD for x years in advance and inherits of base table.
with this
CHECK (_received >= '2013-01-01 00:00:00+11'::timestamp with time zone AND _received < '2013-02-01 01:00:00+11'::timestamp with time zone)

now for the insert, do I create / update this monthly have had a 2 or 3 level if then check before inserting

or do I create a programatic insert that works out the table name

On 27 July 2017 at 18:36, John R Pierce <pierce@hogranch.com> wrote:
On 7/27/2017 12:43 AM, Alex Samad wrote:

... as long as the queries stay on a small amount of parts that we should be okay.

thats true as long as the planner can restrict the queries to the correct partition...  but there's lots of queries that end up having to hit all partitions because the planner can't guess correctly.



--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Index Only Scan and Heap Fetches
Следующее
От: Igor Korot
Дата:
Сообщение: [GENERAL] Why am I getting doubles?