Re: FSM search modes - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: FSM search modes
Date
Msg-id 4AC49338020000250002B546@gw.wicourts.gov
Whole thread Raw
In response to Re: FSM search modes  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: FSM search modes
Re: FSM search modes
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> wrote:
> It would be more useful to think of this as "look for huge chunks of
> space and fill them" rather than "start at beginning", since space
> won't always be right at start.
Either I misunderstand you or I disagree.  If there's a huge chunk of
space near the end, and many many smaller spaces spread throughout,
what I'd like is for rows to be placed in those small ones.  This
would minimize the number of pages to read for queries, and would
present some possibility that the rows past the huge chunk might
eventually be deleted or non-HOT updated, allowing the bloat to
eventually be cleaned up with minimal pain.
-Kevin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FSM search modes
Next
From: Tom Lane
Date:
Subject: Re: Limit allocated memory per session