Dinko Papak <rimokatolik@xxxxxxxxxxx> writes: > Here are 3 interesting (to me) numbers: > 1. creating index on expression (func(timestamp)) takes 5 seconds > 2. creating check constraint on the same expression takes 10 seconds > 3. adding partition table based on the same expression without check expression takes 20 seconds (this has been resolved by answer from David Rowley) Hmm ... > Is it possible to use indices to create check expressions? No. > Why is 2. twice as long as 1.? Good question. Could you provide a concrete test case? regards, tom lane
