On 2014-04-09 16:40, Ken Barber wrote:
2) Why would allowing one or both of the Bigs prevent Number from being
allowed as a serializable type?
Not sure I said that. The problem is that if something is potentially
Big... then a database must be prepared to deal with it and it has a
high cost.
Every Puppet value is potentially a Big now. What new cost is involved?
I'm having trouble seeing how a database can deal efficiently with Puppet's
current implicit typing anyway, Big values notwithstanding. Without
additional type information, it must be prepared for any given value to be a
boolean, an Integer, a float, or a 37kb string (among other possibilities).
Why do Big values present an especial problem in that regard?
So right now, we have alternating native postgresql columns for the
bare types: text, biginteger, boolean, double precision. This provides
us with the ability to use the most optimal index for the type, and of
course avoid storing any more then we need to. As I mentioned at the
top of the thread, we specifically do not support arbitrary precision
decimals.
At least one example in PostgreSQL, once you jump to say, a numeric
column type the performance characteristics and index efficiency
changes for the worse. Same goes for floats being stored in a numeric.
This is why you are better off avoiding the conversion until you
overflow and absolutely need a decimal usually.
ken.
Does that mean you (i.e. Puppet DB) are already prepared to handle
"anytype" so that if we encode all numbers smaller than int64/binary64
as such, and only larger values as a BigType then it would work by
adding those as alternative storage forms?
Or do you expect a given named attribute to have a given storage type at
all times?
- henrik
--
Visit my Blog "Puppet on the Edge"
http://puppet-on-the-edge.blogspot.se/
--
You received this message because you are subscribed to the Google Groups "Puppet
Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-dev/lua850%24rnm%241%40ger.gmane.org.
For more options, visit https://groups.google.com/d/optout.
