On Thu, Jan 31, 2019 at 1:43 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > I have an idea -- instead of adding a bunch of records and hoping that > > the relation size and free space is consistent across platforms, how > > about we revert to the original test input, and add a BRIN index? That > > should have a FSM even with one record. > > > > Why would BRIN index allow having FSM for heap relation?
Oops, I forgot this file is for testing heaps only. That said, we could possibly put most of the FSM tests such as SELECT * FROM fsm_page_contents(get_raw_page('test_rel_forks', 'fsm', 0)); into brin.sql since we know a non-empty BRIN index will have a FSM. And in page.sql we could just have a test that the table has no FSM. -- John Naylor https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services