To all,
Before I begin, this is NOT a PostgreSQL verses mySQL post. I have used
both databases and have found both of these products to be excellent choices
depending on the specific requirements for a given project. That said, I
am trying to understand the database size differences between P
Bruce,
I have your book right in front of me... do you have that information in the
book? If not, I will take a look at the FAQ. As for mySQL, here are the
storage requirements:
Storage requirements for numeric types
Column type Storage required
TINYINT 1 byte
SMALLINT
OK, but that only accounts for 3.2MB of the extra 49.6MB used by PostgreSQL.
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 2:05 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PostgreSQL and mySQL database size questio
Tom,
Again, thank you for your quick and knowledgeable assistance.
After dropping and recreating the indexes I have (in KB):
oldnew
PostgreSQL pinndex_seq 8 8
pinndx 7,856 7,856
pinndx_pkey 6,984 6,984 (did not recreate)
