Re: pg12 - migrate tables to partitions structure

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: pg12 - migrate tables to partitions structure
Дата
Msg-id CAHOFxGpowLyS1gDzc6CMLVzpE2AmoQzxUpFads98aCJxkan7Xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg12 - migrate tables to partitions structure  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
Is this being done because it can be, or is it solving a real-life pain point? Just wondering what the perspective is here.

Much of partitioning strategy seems to me to revolve around how the system is used, and not just the schema and what is possible. For instance, you can mimic primary and foreign key behavior with triggers as described here, and that would bypass some of the restrictions on what can be done.

This would allow you to change out the primary key for a simple index perhaps, and partition however you want. Just because something can be done, does not mean it should be.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Question regarding fast-hashing in PGSQL
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Surprising benchmark count(1) vs. count(*)