Re: PostgreSQL and mySQL database size question

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

In response to

Browse pgsql-general by date

  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?!