Re: [HACKERS] free space map and visibility map

2017-03-28 Thread Kyotaro HORIGUCHI
Hello, At Tue, 28 Mar 2017 08:50:58 -0700, Jeff Janes wrote in

Fwd: [HACKERS] free space map and visibility map

2017-03-28 Thread Jeff Janes
I accidentally sent this off-list, sending to the list now: On Sun, Mar 26, 2017 at 10:38 PM, Kyotaro HORIGUCHI < horiguchi.kyot...@lab.ntt.co.jp> wrote: > At Sat, 25 Mar 2017 19:53:47 -0700, Jeff Janes > wrote in

Re: [HACKERS] free space map and visibility map

2017-03-27 Thread Kyotaro HORIGUCHI
I'd like to have a comment from Heikki or Tom. At Mon, 27 Mar 2017 16:49:08 +0900, Masahiko Sawada wrote in > On Mon, Mar 27, 2017 at 2:38 PM, Kyotaro HORIGUCHI > wrote:

Re: [HACKERS] free space map and visibility map

2017-03-27 Thread Masahiko Sawada
On Mon, Mar 27, 2017 at 2:38 PM, Kyotaro HORIGUCHI wrote: > At Sat, 25 Mar 2017 19:53:47 -0700, Jeff Janes wrote > in

Re: [HACKERS] free space map and visibility map

2017-03-26 Thread Kyotaro HORIGUCHI
At Sat, 25 Mar 2017 19:53:47 -0700, Jeff Janes wrote in

Re: [HACKERS] free space map and visibility map

2017-03-25 Thread Jeff Janes
On Thu, Mar 23, 2017 at 7:01 PM, Kyotaro HORIGUCHI < horiguchi.kyot...@lab.ntt.co.jp> wrote: > At Wed, 22 Mar 2017 02:15:26 +0900, Masahiko Sawada > wrote in gmail.com> > > On Mon, Mar 20, 2017 at 11:28 PM,

Re: [HACKERS] free space map and visibility map

2017-03-23 Thread Masahiko Sawada
On Fri, Mar 24, 2017 at 11:01 AM, Kyotaro HORIGUCHI wrote: > At Wed, 22 Mar 2017 02:15:26 +0900, Masahiko Sawada > wrote in >> On Mon, Mar 20, 2017 at 11:28 PM, Robert

Re: [HACKERS] free space map and visibility map

2017-03-23 Thread Kyotaro HORIGUCHI
At Wed, 22 Mar 2017 02:15:26 +0900, Masahiko Sawada wrote in > On Mon, Mar 20, 2017 at 11:28 PM, Robert Haas wrote: > > On Sat, Mar 18, 2017 at 5:42 PM, Jeff Janes

Re: [HACKERS] free space map and visibility map

2017-03-21 Thread Masahiko Sawada
On Mon, Mar 20, 2017 at 11:28 PM, Robert Haas wrote: > On Sat, Mar 18, 2017 at 5:42 PM, Jeff Janes wrote: >> Isn't HEAP2_CLEAN only issued before an intended HOT update? (Which then >> can't leave the block as all visible or all frozen). I think the

Re: [HACKERS] free space map and visibility map

2017-03-20 Thread Robert Haas
On Sat, Mar 18, 2017 at 5:42 PM, Jeff Janes wrote: > Isn't HEAP2_CLEAN only issued before an intended HOT update? (Which then > can't leave the block as all visible or all frozen). I think the issue is > here is HEAP2_VISIBLE or HEAP2_FREEZE_PAGE. Am I reading this

Re: [HACKERS] free space map and visibility map

2017-03-18 Thread Jeff Janes
On Sat, Mar 18, 2017 at 2:09 PM, Masahiko Sawada wrote: > On Fri, Mar 17, 2017 at 9:37 PM, Jeff Janes wrote: > > With some intensive crash-recovery testing, I've run into a situation > where > > I get some bad table bloat. There will be large swaths

Re: [HACKERS] free space map and visibility map

2017-03-18 Thread Masahiko Sawada
On Fri, Mar 17, 2017 at 9:37 PM, Jeff Janes wrote: > With some intensive crash-recovery testing, I've run into a situation where > I get some bad table bloat. There will be large swaths of the table which > are empty (all results from heap_page_items other than lp are

[HACKERS] free space map and visibility map

2017-03-17 Thread Jeff Janes
With some intensive crash-recovery testing, I've run into a situation where I get some bad table bloat. There will be large swaths of the table which are empty (all results from heap_page_items other than lp are either zero or NULL), but have zero available space in the fsm, and are marked as