| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Jeremy Trammell <jtrammell(at)rpco2(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Smaller template database? |
| Date: | 2003-08-01 15:14:58 |
| Message-ID: | Pine.LNX.4.33.0308010912570.29728-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 25 Jul 2003, Jeremy Trammell wrote:
> Hi all,
>
> I am trying to use PostgreSQL as an embedded SQL database server, but
> the 30 meg installation size is killing me... A quick scan of the
> various docs/FAQs around here have made no mention of any way to trim
> down that template database. Am I missing something? Why must it be so
> large?
Are you sure all that is the template0/1 databases? With WAL segments
taking 16 Megs by default, that may be half of it.
If you're looking for a better choice for imbedding, look at firebird.
http://sourceforge.net/projects/firebird/
It's got a much smaller footprint and doesn't require as much regular
daily maintenance as Postgresql does.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris White (cjwhite) | 2003-08-01 15:18:43 | Problem restoring large objects with pg_restore |
| Previous Message | Tom Lane | 2003-08-01 15:13:11 | Re: fyi regarding error I've seen posted before |