| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: moving from MySQL to pgsql |
| Date: | 2012-10-11 21:06:14 |
| Message-ID: | 507734C6.5030508@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/11/12 2:07 AM, Vineet Deodhar wrote:
> To give an example, I have tables for storing master records (year
> master, security master, etc.) for which pkid TINYINT is just sufficient.
> These pkid's are used as fk constraints in tables for storing business
> transactions.
> The no. of rows in business transactions tables is in millions.
> Here, I NEED to worry about the storage space occupied by the pkid fields.
IMHO, its not significant to save a byte per field unless there's 30 or
100 of these fields in a single row.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-10-11 21:06:23 | Re: non-integer constant in ORDER BY: why exactly, and documentation? |
| Previous Message | David Johnston | 2012-10-11 20:59:35 | Re: non-integer constant in ORDER BY: why exactly, and documentation? |