On Wed, May 4, 2016 at 1:39 AM, Maxim Boguk wrote:
>> This sounds like a known issue, fixed in 9.6, where the pages used for
>> the pending list do not eligible for recycling until the table is
>> vacuumed. Autovacuum does not run on insert only tables, so they just
>> accumulate as empty pages
On Wed, May 4, 2016 at 3:45 AM, Jeff Janes wrote:
> On Tue, May 3, 2016 at 3:09 AM, Maxim Boguk wrote:
> > Hi,
> >
> > I started with empty table with index over
> > custom_fields | jsonb
> > field
> > defined as:
> > "idx_learners_custom_fields" gin (custom_fields)
> > Globally gin_pending
On Tue, May 3, 2016 at 3:09 AM, Maxim Boguk wrote:
> Hi,
>
> I started with empty table with index over
> custom_fields | jsonb
> field
> defined as:
> "idx_learners_custom_fields" gin (custom_fields)
> Globally gin_pending_list_limit set to 2MB.
> Database version is 9.5.2.
>
> Now question:
On Tue, May 3, 2016 at 1:35 PM, Maxim Boguk wrote:
>
>
> On Tue, May 3, 2016 at 8:09 PM, Maxim Boguk wrote:
>
>> Hi,
>>
>> I started with empty table with index over
>> custom_fields | jsonb
>> field
>> defined as:
>> "idx_learners_custom_fields" gin (custom_fields)
>> Globally gin_pending_
On Tue, May 3, 2016 at 8:09 PM, Maxim Boguk wrote:
> Hi,
>
> I started with empty table with index over
> custom_fields | jsonb
> field
> defined as:
> "idx_learners_custom_fields" gin (custom_fields)
> Globally gin_pending_list_limit set to 2MB.
> Database version is 9.5.2.
>
> Now question
Hi,
I started with empty table with index over
custom_fields | jsonb
field
defined as:
"idx_learners_custom_fields" gin (custom_fields)
Globally gin_pending_list_limit set to 2MB.
Database version is 9.5.2.
Now question:
If table populated with 1M records in single transaction then the final
