Re: All Taxi Services need Index Clustered Heap Append

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