|
> From: bexley401@xxxxxxxxx
> To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: New Zealand Postgis DBA job vacancy > > > Thinking (entirely) *in* metric doesn't. The problem is working > with *both*, simultaneously, requires some mental agility. > > Nearby, we have one of the few (only?) stretches of roadway that > is marked in metric units (actually, I haven't driven it in a while > and vaguely recall something about RE-marking it in "conventional" > units). To most folks, it is a disturbing experience as they aren't > accustomed to thinking in these. ("No, that's not 100MPH but > 100kmph... big difference!") MG>Posted Speed limit in the mahority of limited access highways in SouthAmerica is 100 MG>unless of course ...you're in a hurry > > > > so...why doesn't Postgres port to embedded systems? > > IME, it requires lots of resources (the vast majority of embedded > systems are resource starved -- resources == $$ and when you are > selling things in volume, every penny saved adds up quickly!). > Lots of MIPS, lots of RAM -- even the code footprint is "significant". > > OTOH, (again, IME) designing with the "relational table" construct > makes coding a very different experience! Already being biased > in favor of table-driven algorithms, I took this opportunity to > move all the "const" tables out of my executables and into the > DBMS (which takes a performance hit but keeps the code much more > mutable). I've gone so far as to hide the filesystem from the > applications -- objects that would have typically resided in > ad hoc files are now stored in structured tables (eliminates > the need to write lots of special parsers to be able to impose > structure on what would otherwise be unstructured "bytes") > MG>so do you reduce CPU or IO when you take a java variable final int foo=1; and insert foo as a const column in a table? MG>BTW Spring IOC has addressed this issue with lazy-init="true" (dont initialise the variable until referenced at runtime) > > --don MG>Martin > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
