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 JDBC
/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 Rogers
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?
http
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, please send an appropriate
to 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. Andrew Rogers
[EMAIL
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. Andrew Rogers
[EMAIL PROTECTED]
---(end
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?
http
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)---
TIP 9
is a 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
.
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 Rogers
---(end of broadcast
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
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)---
TIP 1
).
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 broadcast)---
TIP 1: if posting
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
---(end of broadcast
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
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 appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
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] so that your
message can get through to the mailing list
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: if posting/reading through Usenet, please send an appropriate
. 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
---(end of broadcast
to more widespread adoption.
There is no *technical* reason things should be done this way and it
might even go against the sensibilities of many current users. But it
would go a long way toward widening the audience.
j. andrew rogers
---(end of broadcast
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
23 matches
Mail list logo
