Re: Speed & Memory Management

From: Juan Miguel <juanmime(at)ono(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Speed & Memory Management
Date: 2003-04-02 21:13:17
Message-ID: 200304022313.17633.juanmime@ono.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> That would buy you absolutely nothing. char() is not faster than text.
> Instead you would make everything slower because the system would
> constantly have to pad and trim your values and it would bloat the storage
> with the extra spaces.

First, sorry about my english.

Well ... but ... reading database theory books, you can see that fixed size
records are "better" than variant size records. When the records are size
fixed, inserts, updates and deletes can recalculate easier the position of
the rest records in the pages. These books tell you that in general cases,
variant record size tables (records that have variant type colums, for
example) imply a lower performance in the system ...

Why in postgresql these things don't matter ?

Thanks.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-04-02 22:20:40 Re: Speed & Memory Management
Previous Message lists 2003-04-02 20:22:50 restore time