Disk space nescessary for PK creation on 70 mln records table? - Mailing list pgsql-admin

From swanio@poczta.fm (Sebastian)
Subject Disk space nescessary for PK creation on 70 mln records table?
Date
Msg-id 28988069.0407222354.f84d44b@posting.google.com
Whole thread Raw
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Negyesi Karoly
Date:
Subject: replication and linux-ha?
Next
From: "Goulet, Dick"
Date:
Subject: Re: please please please PLEASE help!