Thread: Size of the Postgres DB

Hi,

I would like to know if I can reduce the size of the database at creating
time, cause mine is empty and is 20 MO!!

Yannick

Yannick,

> I would like to know if I can reduce the size of the database at
>  creating
> time, cause mine is empty and is 20 MO!!

Um ... do you mean 20MB?

To shrink a PostgreSQL database down to its most reasonable size:  Run
 VACUUM.  That's what it's for.

-Josh

P.S. Since when is 20MB a huge database?

Yannick,

> Thanks for your answer, I mean 20 Mo is a Hudge database when yo want
>  to use
> it as a embedded database...when you have 32- or 64 Mo of
>  disk-on-chip
> memory

You need to talk to others who have done PostgreSQL embedded.  Try
 sending an e-mail to pgsql-hackers to see if there's anyone there.

-Josh

IIRC, most of that space is taken up by the
xlog segment.  I believe that you may
be able to play with XLogSegSize in
include/access/xlog.h to lower this usage, but I've
never done it, so I don't know if it's safe.

--- Josh Berkus <josh@agliodbs.com> wrote:
> Yannick,
>
> > Thanks for your answer, I mean 20 Mo is a Hudge
> database when yo want
> >  to use
> > it as a embedded database...when you have 32- or
> 64 Mo of
> >  disk-on-chip
> > memory
>
> You need to talk to others who have done PostgreSQL
> embedded.  Try
>  sending an e-mail to pgsql-hackers to see if
> there's anyone there.


__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/