| From: | "Len Morgan" <len-morgan(at)crcom(dot)net> |
|---|---|
| To: | "Joseph Shraibman" <jks(at)p1(dot)selectacast(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: why so big? |
| Date: | 2000-05-17 21:53:23 |
| Message-ID: | 010501bfc04a$54021a00$0908a8c0@H233.bstx.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----Original Message-----
From: Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>
To: pgsql-general(at)hub(dot)org <pgsql-general(at)hub(dot)org>
Date: Wednesday, May 17, 2000 4:33 PM
Subject: [GENERAL] why so big?
>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
Overhead! I think you will find that 8K is the smallest file that can be
allocated if you add one record to a table, the index isn't going to get any
bigger for a while until it fills up the 16K.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-05-17 22:04:48 | Re: 7.0 psql, readline and history. |
| Previous Message | Joseph Shraibman | 2000-05-17 21:25:27 | why so big? |