Re: URGENT: Storage disk - Mailing list pgadmin-support

From Tino Wildenhain
Subject Re: URGENT: Storage disk
Date
Msg-id 151693463.1038145607@liza
Whole thread Raw
In response to URGENT: Storage disk  (Ana Claudia <ana-b-dias@ptinovacao.pt>)
List pgadmin-support
Hi Ana,

I dont think this is any related to pgadmin, but anyway:
On i386 the binary for 7.2 is about 3.5MB + 0.5MB libs
So you can store some data on the remaining 20MB (if you
take in account what an initdb will cost space)
Its of course depending on what data you want to store
and how many indices you want to create. It also depends
on the architecture. May be other DBs can have a smaller
footprint on the binaries, but I dont think they are
also smaller with the data. (Postgres stores Text fields
always compressed)
It will have nothing to do with the kernel (other then the
Filesystem you want to use as different filesystems use
different block sizes) If the whole system and the db schould
fit along with many data, you should consider buying a larger
CF disk, they are not so expensive anymore.

Regards
Tino

--On Freitag, 22. November 2002 15:13 +0000 Ana Claudia
<ana-b-dias@ptinovacao.pt> wrote:

> Hello,
>
> I need to know if is possible to have postgres database on Flash Disk
> where the space for database is 32Mb (including data).
> If the answer is positive, what is the configuration for postgres (and
> Kernel)?
> If isn't possible, can you tell me a database (freeware or open source)
> for that.
>
> Thanks.
>
> Best Regards,
>
> Ana Cláudia
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re:
Next
From: Tino Wildenhain
Date:
Subject: Re: URGENT: Storage disk