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