Re: Vacuum: allow usage of more than 1GB of work mem
Claudio Freire <klaussfreire@gmail.com>
From: Claudio Freire <klaussfreire@gmail.com>
To: Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Cc: Anastasia Lubennikova <lubennikovaav@gmail.com>,
PostgreSQL-Dev <pgsql-hackers@postgresql.org>
Date: 2016-12-27T17:14:39Z
Lists: pgsql-hackers
On Tue, Dec 27, 2016 at 10:41 AM, Anastasia Lubennikova <a.lubennikova@postgrespro.ru> wrote: > Program terminated with signal SIGSEGV, Segmentation fault. > #0 0x00000000006941e7 in lazy_vacuum_heap (onerel=0x1ec2360, > vacrelstats=0x1ef6e00) at vacuumlazy.c:1417 > 1417 tblk = > ItemPointerGetBlockNumber(&seg->dead_tuples[tupindex]); > (gdb) bt > #0 0x00000000006941e7 in lazy_vacuum_heap (onerel=0x1ec2360, > vacrelstats=0x1ef6e00) at vacuumlazy.c:1417 > #1 0x0000000000693dfe in lazy_scan_heap (onerel=0x1ec2360, options=9, > vacrelstats=0x1ef6e00, Irel=0x1ef7168, nindexes=2, aggressive=1 '\001') > at vacuumlazy.c:1337 > #2 0x0000000000691e66 in lazy_vacuum_rel (onerel=0x1ec2360, options=9, > params=0x7ffe0f866310, bstrategy=0x1f1c4a8) at vacuumlazy.c:290 > #3 0x000000000069191f in vacuum_rel (relid=1247, relation=0x0, options=9, > params=0x7ffe0f866310) at vacuum.c:1418 Those line numbers don't match my code. Which commit are you based on? My tree is (currently) based on 71f996d22125eb6cfdbee6094f44370aa8dec610
Commits
-
Prefetch blocks during lazy vacuum's truncation scan
- 7e26e02eec90 10.0 landed
-
Explain unaccounted for space in pgstattuple.
- 71f996d22125 10.0 cited