Thread: Compaq iPAQ and Postgresql
Hello folks!
We are using a Compaq iPAQ with 32 MB of RaM.
Now we thinking about the size of the postmaster, because we wanna use
Postgres on it.
If we are performing big Querys, the used size of the postmaster could
be more than 32 MB.
It would be a good idea, if the
postmaster would send a Warning signal, if the Ram is full,
or otherwise
could I limit the space for the postmaster?
DO You have anything Experience with POSTGRESQL on
PDA(Personal Digital Assistant) or other little Computers?
All suggestions will receive my gratitudes
David
Attachment
Hi David, I am running PostgreSQL on a Cyrix 686 - Linux box with only 32MB of RAM. (For a while even with 16 MB). But there is no real data ... less than 100 rows in two or three tables. AFAIK there should be no problem with low RAM ... but performance will slow down. There should be some hints on tuning postgres at the tech docs. Maybe these would be helpfull to reduce RAM-usage (but normally you'll find hint, how to increase it ;-). Andre ----- Original Message ----- From: "David M. Richter" <d.Richter@dkfz-heidelberg.de> To: <pgsql-general@postgresql.org> Sent: Wednesday, August 29, 2001 9:57 AM Subject: [GENERAL] Compaq iPAQ and Postgresql > Hello folks! > > We are using a Compaq iPAQ with 32 MB of RaM. > Now we thinking about the size of the postmaster, because we wanna use > Postgres on it. > If we are performing big Querys, the used size of the postmaster could > be more than 32 MB. > > It would be a good idea, if the > > postmaster would send a Warning signal, if the Ram is full, > or otherwise > could I limit the space for the postmaster? > > > DO You have anything Experience with POSTGRESQL on > PDA(Personal Digital Assistant) or other little Computers? > > All suggestions will receive my gratitudes > > David ---------------------------------------------------------------------------- ---- > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
But on an ipaq data isn't stored on disk, it is all stored in memory. Andre Schnabel wrote: > Hi David, > > I am running PostgreSQL on a Cyrix 686 - Linux box with only 32MB of RAM. > (For a while even with 16 MB). > But there is no real data ... less than 100 rows in two or three tables. > > AFAIK there should be no problem with low RAM ... but performance will slow > down. > There should be some hints on tuning postgres at the tech docs. Maybe these > would be helpfull to reduce RAM-usage (but normally you'll find hint, how to > increase it ;-). > > > > Andre > > ----- Original Message ----- > From: "David M. Richter" <d.Richter@dkfz-heidelberg.de> > To: <pgsql-general@postgresql.org> > Sent: Wednesday, August 29, 2001 9:57 AM > Subject: [GENERAL] Compaq iPAQ and Postgresql > > > >>Hello folks! >> >>We are using a Compaq iPAQ with 32 MB of RaM. >>Now we thinking about the size of the postmaster, because we wanna use >>Postgres on it. >>If we are performing big Querys, the used size of the postmaster could >>be more than 32 MB. >> >>It would be a good idea, if the >> >> postmaster would send a Warning signal, if the Ram is full, >> or otherwise >> could I limit the space for the postmaster? >> >> >>DO You have anything Experience with POSTGRESQL on >>PDA(Personal Digital Assistant) or other little Computers? >> >>All suggestions will receive my gratitudes >> >> David >> > > > ---------------------------------------------------------------------------- > ---- > > > >>---------------------------(end of broadcast)--------------------------- >>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
> But on an ipaq data isn't stored on disk, it is all stored in memory. Hmmm... sorry, didn't get that point. So you'll get a real problem. AFAIK PostgreSQL will use diskspace if more space is needed for sorts and other things, than RAM is available (better if neded space exceeds the given values in postgresql.conf) But if disk is in RAM ..... Maybe one of the developers can tell, what would happen. I think, you would need a very spezialised code to run on diskless hosts. Andre
Hi, we would anyway use a microdrive. We have quite large DICOM images so only a few would fit into RAMdisk/Flash on the iPAQ. We could use DICOMDIR then although it's not very performant. Maybe this situtation changes with 32MB of FlashROM and 64MB of RAM as proposed in future iPAQ releases. Tilman