От: Ron
Отправлено: 18 июля 2023 г. 9:48
Кому: pgsql-general@lists.postgresql.org
Тема: Re: suggestion about time based partitioning and hibernate
On 7/18/23 01:18, Luca Ferrari wrote:
Dear all,
I'm looking for ideas here, and it could be someone already stepped
into declarative part
>>-Исходное сообщение-
>>От: Laurenz Albe
>>Отправлено: 22 февраля 2023 г. 12:52
>>Кому: Neethu P ; pgsql-general
>>
>>Тема: Re: Event Triggers unable to capture the DDL script executed
>>On Wed, 2023-02-22 at 07:57 +, Neethu P wrote:
>>> We are using event triggers to capture the
> writes:
> > Oh, I did not explicitly write that, in case of custom plan (first
attempts or with force_custom_plan) database
> > holds only a couple of locks!
> > Why in this > case it is sufficient to lock only one partition and
parent table ?
> Because partition routing is done at planning
> > On Wed, 2022-11-09 at 14:11 +0300, n.kobza...@aeronavigator.ru wrote:
> > Recently I`ve been pushing into life a new project and immediately
> > experienced an Out of shared memory error while querying partitioned tables.
> >
> > ERROR: out of shared memory
> > Hint: You might need to incr
Hello!
Recently I`ve been pushing into life a new project and immediately
experienced an Out of shared memory error while querying partitioned tables.
Imagine a huge busy table that you want to split into hundreds of partitions
by list. Partition key is a kind of surrogate key that can be c
