Strange optimization - xmin,xmax compression :)

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Strange optimization - xmin,xmax compression :)
Date: 2010-12-06 14:30:34
Message-ID: AANLkTimjHqOnw5b5R7mLSwAAWj2jpFPaurUHf1Eaw5Nz@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

hello.

i tested how are distributed values xmin,xmax on pages.
in my tables . typically there are no more than 80 records
on pages.

maybe its possible to compress xmin & xmax values to
1 byte/per record (+table of transactions per page)?
its reduce the space when more than 1 record is
from the same transaction.

Testing query:

SELECT
(string_to_array(ctid::text,','))[1] as page
,count(*) as records
,array_upper(array_agg(distinct (xmin::text)),1) as trans
FROM only
"Rejestr stacji do naprawy"
group by
(string_to_array(ctid::text,','))[1]
order by
3 desc

------------
pasman

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-12-06 17:10:19 Re: Performance under contention
Previous Message Jignesh Shah 2010-12-06 07:27:10 Re: Group commit and commit delay/siblings