Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-admin by date

Next:From: Werner vd MerweDate: 2004-07-23 11:23:16
Subject: Profiling
Previous:From: Oliver ElphickDate: 2004-07-23 07:38:39
Subject: Re: pg_autovacuum problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group