From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | ingham(at)erols(dot)com |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL and mySQL database size question |
Date: | 2001-04-27 20:12:27 |
Message-ID: | 200104272012.PAA01543@jupiter.jw.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Fred Ingham wrote:
> OK, but that only accounts for 3.2MB of the extra 49.6MB used by PostgreSQL.
Template databases, system catalog, WAL files?
>
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Friday, April 27, 2001 2:05 PM
> To: ingham(at)erols(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] PostgreSQL and mySQL database size question
>
>
>
> FAQ item 4.7 discusses table size computations. My guess is that it is
> the 36 bytes-per-row that is the problem. Those bytes record the
> visibility of the row for proper transactions semantics and MVCC.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Mikheev, Vadim | 2001-04-27 20:45:39 | RE: WAL Log using all my disk space! |
Previous Message | Sterling | 2001-04-27 20:07:55 | Re: SQL Where Like - Range it?! |