Re: [HACKERS] Placing hints in line pointers

2013-06-10 Thread Greg Stark
On Mon, Jun 10, 2013 at 3:43 AM, Jeff Davis wrote: >> We wouldn't need to do a FPW when a hint changes, we would only need >> to take a copy of the ItemId array, which is much smaller. And it >> could be protected by its own checksum. > > I like the direction of this idea. One of the previous pro

Re: [HACKERS] Placing hints in line pointers

2013-06-09 Thread Jeff Davis
On Sat, 2013-06-01 at 15:45 +0100, Simon Riggs wrote: > Doing this would have two purposes: > > * We wouldn't need to follow the pointer if the row is marked aborted. > This would save a random memory access for that tuple That's quite similar to LP_DEAD, right? You could potentially set this new

[HACKERS] Placing hints in line pointers

2013-06-01 Thread Simon Riggs
Notes on a longer term idea... An item pointer (also called line pointer) is used to allow an external pointer to an item, while allowing us to place the tuple that anywhere on the page. An ItemId is 4 bytes long and currently consists of (see src/include/storage/itemid.h)... typedef struct ItemI