Re: [GENERAL] CLUSTERing on Insert

2006-09-22 Thread Jim C. Nasby
I believe there's a TODO item for index-organized tables/clustered tables. If not, there's certainly been discussion about it on the -hackers list. On Sun, Sep 17, 2006 at 10:21:27PM -0700, CG wrote: > As I'm waiting for a CLUSTER operation to finish, it occurs to me that in a > lot of cases, the

[GENERAL] CLUSTERing on Insert

2006-09-17 Thread CG
As I'm waiting for a CLUSTER operation to finish, it occurs to me that in a lot of cases, the performance benefits to having one's data stored on disk in index order can outweigh the overhead involved in inserting data on-disk in index order Just an idea I thought I'd throw out. :) Also,