om if we made incremental changes to a solid disk-based engine. It
seems short-term expedient but long-term bad engineering -- think MySQL.
Cheers,
J. Andrew Rogers
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Oct 27, 2007, at 2:20 PM, Florian Weimer wrote:
* J. Andrew Rogers:
Everything you are looking for is here:
http://web.mit.edu/dna/www/vldb07hstore.pdf
It is the latest Stonebraker et al on massively distributed in-memory
OLTP architectures.
"Ruby-on-Rails compiles into standard
a/www/vldb07hstore.pdf
It is the latest Stonebraker et al on massively distributed in-memory
OLTP architectures.
J. Andrew Rogers
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
.
A popular alternative to CRC32 for this purpose is the significantly
cheaper and almost as effective is the Adler32 algorithm. I know
Google used this algorithm when they added checksumming to their
database to tame inexplicable transient corruption.
Cheers,
J. Andrew R
ty of use for loosening restrictions on
databases where the contents do not matter and a little loss is
acceptable.
Cheers,
J. Andrew Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Have you searched our list archives?
roader picture. Having a theoretically (mostly) complete set of
usable primitives would be an incredibly powerful feature set.
Cheers,
J. Andrew Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, p
2.3 or 2.4.
Python 2.5 may be the current "stable" version, but vanilla source
builds segfault on some Python code that runs fine in 2.3 and 2.4,
strongly suggesting that it is not mature enough that I would put it
anywhere near anything important (like a database).
J. And
over that I can step through every
single action they took to destroy their own data. I've never seen a
single case like the one described above that was due to an internal
database failure; when there is an internal database failure, it is
usually ugly and obvious.
Cheers,
J. Andre
g spatial index types that a
researcher might be interested in implementing.
Cheers,
J. Andrew Rogers (who is also implementing new spatial indexes...)
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
tice the engine is not up to the more
rigorous demands of that kind of work.
With the nascent rise of the geospatial web, it is going to become a
lot more important than it has been.
J. Andrew Rogers
[EMAIL PROTECTED]
---(end of broadcast)--
functional implementation (and probably recommended in
practice), though most real implementations allow external indexes if
not always in their first version.
J. Andrew Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: In versions below 8.0
d platforms will
definitely scare them away.
A graphical installer for Unix is fine, but please, do not make it
anything like Oracle's graphical installer. Oracle's graphical
install process gives command line installs a good name for ease of use.
J. Andrew Rog
rt, I would say that
this is the future of server boards.
And if postgres could actually use an infiniband fabric for
clustering a single database instance across Opteron servers, that
would be very impressive...
J. Andrew Rogers
---(end of broadcast)
port. At that level of
bandwidth and latency, both per node and per switch fabric, the
architecture possibilities start to become intriguing.
J. Andrew Rogers
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ad and a large numeric (what we
> have today).
The 38 digit limit is the decimal size of a 128-bit signed integer. The
optimization has less to do with the size of the length info and more to do
with fast math and fixed structure size.
J. Andrew Rogers
---(end of br
te strings (for ASN.1, even
integers and similar are encoded this way to shave bytes on them as well but
that seems excessive). It would be useful to see how encoding/decoding cost
balances out the more compact representation in terms of performance.
J. Andrew Rogers
I
spend my time on with PostgreSQL. There is currently no good way to
approximate it.
J. Andrew Rogers
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
g
that is decidedly non-novel. In other words, the
"novel-ness" is the semantic dressing-up of a non-novel
engineering process.
cheers,
j. andrew rogers
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
e development of the software by hackers has worked out pretty
well, at least for me. People say that is a bad thing about a lot of
OSS, but I actually think it was needed in RDBMS software.
j. andrew rogers
---(end of broadcast)---
TIP 3
y obvious reason why it couldn't be done well
with a moderate amount of effort.
j. andrew rogers
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
gs we will probably never know. Whatever its
historical purpose, DUAL has been so pervasively used in the Oracle
universe for so long that giving it a better name would break virtually
every Oracle application in existence. It is an institution unto
itself.
j. andrew rogers
---
rger Postgres product and mid-level
developer documentation, both of which seem to be eminently solvable
problems. I think improved default product packaging would remove 80%
of the impediment to more widespread adoption.
There is no *technical* reason things should be done this way and it
might even g
I may be completely missing the point here, but it looks to me as though
the PITR archival mechanism is also most of a native replication
facility. Is there anyone reason this couldn't be extended to
replication, and if so, is anyone planning on using it as such?
My memory is fuzzy on this point
23 matches
Mail list logo
