why so big?

From: Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>
To: "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org>
Subject: why so big?
Date: 2000-05-17 21:25:27
Message-ID: 39230E47.25F10FC9@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've just created a new database and I am wondering...

Why are all sequence files 8K? They're one freaking int.

How come the indexes are so large? They tend to be larger than the
database files themselves. In one case I have a 16K index on an empty
table.

-rw------- 1 postgres postgres 0 May 11 19:12 category
-rw------- 1 postgres postgres 16384 May 11 19:13
category_parent_key
-rw------- 1 postgres postgres 16384 May 11 19:12 category_pkey

-rw------- 1 postgres postgres 8192 May 17 03:35 message
-rw------- 1 postgres postgres 8192 May 12 13:26
message_id_seq
-rw------- 1 postgres postgres 16384 May 17 03:35 message_o_key

-rw------- 1 postgres postgres 16384 May 17 03:35 message_pkey
-rw------- 1 postgres postgres 16384 May 17 03:35 message_p_key

Browse pgsql-general by date

  From Date Subject
Next Message Len Morgan 2000-05-17 21:53:23 Re: why so big?
Previous Message Jeffery Collins 2000-05-17 19:19:47 initdb and "exit_nicely"...