Re: Rethinking autovacuum.c memory handling

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Rethinking autovacuum.c memory handling
Date: 2017-09-23 11:14:15
Message-ID: 20170923111415.uswmkulp37k4bzcd@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera wrote:

> One idea I just had is to somehow add it to src/test/modules/brin, and
> set up the postmaster in that test with autovacuum_naptime=1s. I'll go
> check how feasible that is. (By placing it there we could also verify
> that the index does indeed contain the index entries we expect, since it
> has pageinspect available.)

Yeah, this works, as per the attached patch.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
0001-Add-autovacuum-work-items-test-for-BRIN.patch text/plain 2.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2017-09-23 11:16:30 Re: brin_summarize_new_values error checking
Previous Message Alvaro Herrera 2017-09-23 10:30:50 Re: Rethinking autovacuum.c memory handling