Thread: Size of the empty database

Size of the empty database

From
"Yannick ALLUSSE"
Date:
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


Re: Size of the empty database

From
"Henshall, Stuart - WCP"
Date:
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.allusse@kisbv.com]
> Sent: 07 March 2002 07:57
> To: pgsql-novice@postgresql.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
>