Re: URGENT: Storage disk

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: URGENT: Storage disk
Дата
Msg-id 151693463.1038145607@liza
обсуждение исходный текст
Ответ на URGENT: Storage disk  (Ana Claudia <ana-b-dias@ptinovacao.pt>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re:
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: URGENT: Storage disk