| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Thierry Husson <thusson(at)informiciel(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Temp table handling after anti-wraparound shutdown (Was: BUG #15840) |
| Date: | 2019-06-08 01:45:40 |
| Message-ID: | 20190608014540.GC7228@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Fri, Jun 07, 2019 at 05:26:32PM -0700, Andres Freund wrote:
> I was more thinking that we'd move the check for orphaned-ness into a
> separate function (maybe IsOrphanedRelation()), and move the code to
> drop orphan relations into a separate function (maybe
> DropOrphanRelations()). That'd limit the amount of code duplication for
> doing this both in autovacuum and all-database vacuums quite
> considerably.
A separation makes sense. At some point we should actually try to
separate vacuum and orphan relation cleanup, so separate functions
make sense. The only reason why we are doing it with autovacuum is
that it is the only thing in-core spawning a worker connected to a
database which does a full scan of pg_class.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thierry Husson | 2019-06-08 09:06:39 | Re: Temp table handling after anti-wraparound shutdown (Was: BUG #15840) |
| Previous Message | Andres Freund | 2019-06-08 00:26:32 | Re: Temp table handling after anti-wraparound shutdown (Was: BUG #15840) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Avinash Kumar | 2019-06-08 02:43:08 | Bloom Indexes - bit array length and the total number of bits (or hash functions ?? ) ! |
| Previous Message | Michael Paquier | 2019-06-08 01:24:39 | Re: be-gssapi-common.h should be located in src/include/libpq/ |