Thread: URGENT: Storage disk

URGENT: Storage disk

From
Ana Claudia
Date:
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

Re: URGENT: Storage disk

From
Tino Wildenhain
Date:
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

Re: URGENT: Storage disk

From
Tino Wildenhain
Date:
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