Re: All Taxi Services need Index Clustered Heap Append

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: All Taxi Services need Index Clustered Heap Append
Date: 2018-03-10 18:32:35
Message-ID: 1520706755239-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

Would the following custom solution:

- a pre-loaded table rows being sorted by id and ts
containing null values for other columns,
enough free space per block to permit updates in place,
- having a (btree or brin) index on (id,ts),
- loaded using UPDATEs in spite of INSERTs for each new mesure

have a chance to be a good work arround ?

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Dilger 2018-03-10 18:43:31 Re: [HACKERS] PATCH: multivariate histograms and MCV lists
Previous Message Alvaro Herrera 2018-03-10 18:13:09 Re: Fixes for missing schema qualifications