Postgres Pro
Downloads
Home   >   mailing lists

Re: Size of the Postgres DB - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Size of the Postgres DB
Date
Msg-id web-821430@davinci.ethosmedia.com
Whole thread Raw
In response to Size of the Postgres DB  ("Yannick ALLUSSE" <yannick.allusse@kisbv.com>)
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: Joel Burton
Date:
Subject: Re: SQL error 'Unable to identify an operator = for type
Next
From: "Josh Berkus"
Date:
Subject: Re: Good tutorial wanted...