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

From: swanio(at)poczta(dot)fm (Sebastian)
To: pgsql-admin(at)postgresql(dot)org
Subject: Disk space nescessary for PK creation on 70 mln records table?
Date: 2004-07-23 07:54:51
Message-ID: 28988069.0407222354.f84d44b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-admin by date

  From Date Subject
Next Message Werner vd Merwe 2004-07-23 11:23:16 Profiling
Previous Message Oliver Elphick 2004-07-23 07:38:39 Re: pg_autovacuum problem