Re: [HACKERS] [PATCHES] Maintaining cluster order on insert

2006-08-09 Thread Gene
le. What would be an efficient way to do the transfer? Since the updates occur somewhat randomly, wouldnt the tuples in the stable table then be out of natural timestamp order? thanks for all of your help and comments! it is greatly appreciated!Gene HartOn 8/9/06, Tom Lane <[EMAIL PROTECTED]

Re: [HACKERS] [PATCHES] Maintaining cluster order on insert

2006-08-09 Thread Gene
I have a table that inserts lots of rows (million+ per day) int8 as primary key, and I cluster by a timestamp which is approximately the timestamp of the insert beforehand and is therefore in increasing order and doesn't change. Most of the rows are updated about 3 times over time roughly within th