View Single Post

   
  #3 (permalink)  
Old 04-09-2008, 05:58 AM
Kevin Murphy
 
Posts: n/a
Default Re: CLUSTER equivalent

Neil Conway wrote:

> Kevin Murphy wrote:
>
>> I just wanted to confirm that the COPY command always stores data in
>> the table in the order in which it appears in the import file.

>
>
> This is not the case -- depending on the content of the FSM, the newly
> added rows might be distributed throughout the table.


How about for a freshly created, empty table -- I should have qualified
my original statement.

Thanks,
Kevin


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote