Обсуждение: Disk space nescessary for PK creation on 70 mln records table?

Поиск
Список
Период
Сортировка

Disk space nescessary for PK creation on 70 mln records table?

От
swanio@poczta.fm (Sebastian)
Дата:
Hi there,

Can someone estimate disk space nescessary for PK creation on 70 mln records table?

table:

create table some_table (
  col_one char(10) not null,
  col_two smallint not null,
  col_three bool not nul default false
);

PK should be created on "col_one" column.

Also, how much time it can take (on a low-end machine)?

Txh & regards

Sebastian.