Re: Size of the empty database

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Yannick ALLUSSE' <yannick(dot)allusse(at)kisbv(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Size of the empty database
Date: 2002-03-13 15:54:48
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74823@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

PostgreSQL probably isn't the best db for embedded stuff. Each WAL file
alone is 16MB, plus indexes get constantly larger unless you recreate them
(as well as needing to run VACUUM to get rid of dead records). The BerkelyDB
from sleepycat may be worth a look though.
- Stuart

> -----Original Message-----
> From: Yannick ALLUSSE [mailto:yannick(dot)allusse(at)kisbv(dot)com]
> Sent: 07 March 2002 07:57
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Size of the empty database
>
>
> Hi,
>
> I am testing PostgreSQL for an embedded device, but I was
> surprised by the
> size of the database. Just after creating : 20 MB, without
> any table inside.
>
> So I would like to know I can reduce this size...maybe to
> several undred Kb?
>
> Thanks
>
> Yannick
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-03-13 16:14:31 Re: Postmaster with -i
Previous Message Henshall, Stuart - WCP 2002-03-13 15:49:59 Re: Postmaster with -i