Thread: URGENT: Storage disk
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
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
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