Hello.
Basically my implementation serve for the same thing as table_log extension -
entry versioning. It also uses history table and triggers to store old
versions of entries. After quick review of table_log extension, here is
comparison with my solution:
tale_log advantages compared to my
Miroslav Šimulcík wrote:
as a part of my master's thesis I have created temporal support patch for
PostgreSQL. It enables the
creation of special temporal tables with entries versioning. Modifying
operations (UPDATE, DELETE,
TRUNCATE) on these tables don't cause permanent changes to
Hello.
SQL 2011 standard wasn't available in time I started this project so I
built my implementation on older standards TSQL2 and SQL/Temporal, that
were only available. None of these were accepted by ANSI/ISO commissions
however.
There is different syntax in SQL 2011 and it looks like one that
Hi,
yes you are right, storing old versions of entry to history table can be
handled with triggers and my solution also uses triggers to do that.
Advantage of my implementation is that user doesn't need to create all
necessary objects (triggers, history table, begin/end columns ...)
manually. He
On Wed, May 16, 2012 at 4:14 PM, Miroslav Šimulčík
simulcik.m...@gmail.com wrote:
This is only a illustration of main functionality. Later I can create a
document about the design and implementation details, but first I need to
know if such temporal features as described here, could be added
On Fri, May 18, 2012 at 3:57 AM, Joshua Berkus j...@agliodbs.com wrote:
Yeah, I don't know how I produced the crash in the first place, because of
course the self-replica should block all writes, and retesting it I can't get
it to accept a write. Not sure how I did it in the first place.
Hi All,
I just realized that anyone can listen for notifications (using listen)
so long as they know the channel name. This means that a user could
receive and view the payload for another user.
Perhaps it would be good to note this in the documentation (i.e., there
should be no
I've been testing the crash recovery of REL9_2_BETA1, using the same
method I posted in the Scaling XLog insertion thread. I have the
checkpointer occasionally throw a FATAL error, which causes the
postmaster to take down all of the other processes (DETAIL: The
postmaster has commanded this
I bumped into a bug in the new buffering GiST build code. I did this:
create table gisttest (t text);
insert into gisttest select
a||'fooo' from
generate_series(1,1000) a;
create index i_gisttest on gisttest using gist (t collate C) WITH
On Fri, May 18, 2012 at 8:27 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
After fixing that, however, I'm now getting another error, much later in
the build process:
ERROR: failed to re-find parent for block 123002
STATEMENT: create index i_gisttest on gisttest using
It might be easy to detect the situation where the standby has
connected to itself,
e.g., by assigning ID for each instance and checking whether IDs of
two servers
are the same. But it seems not easy to detect the
circularly-connected
two or more
standbys.
Well, I think it would be fine
Fujii,
You mean that remaster is, after promoting one of standby servers,
to make
remaining standby servers reconnect to new master and resolve the
timeline
gap without the shared archive? Yep, that's one of my TODO items, but
I'm not
sure if I have enough time to implement that for
* Stephen Frost (sfr...@snowman.net) wrote:
Alright, so I've done some pgbench's using all default configs with just
a straight up './configure' and pgbench -S -T 300, 3 runs each and then
averaged:
llist_opt: 9289 tps
HEAD: 9286 tps
Ok, apparently part of the issue with the previous
Excerpts from Florian Pflug's message of jue may 17 09:08:26 -0400 2012:
On May16, 2012, at 15:51 , Tom Lane wrote:
It is by design, in that the only contemplated case was truncated-away
pages. I'm pretty hesitant to consider allowing arbitrary kernel errors
to be ignored here …
Maybe
Seems system() call cleanups sigaction state on FreeBSD.
The root of problem is a threading library. In FreeBSD there are two versions of
sigaction() (system() and others) depending on thread enabled. libpq library is
compiled by default with -pthread switch but psql is linked without that.
* Stephen Frost (sfr...@snowman.net) wrote:
llist_opt: 9289 tps
HEAD: 9286 tps
llist_opt: 9407 tps
Which gives us ~1.3% improvment.
Trying out some different options- going with 32 pre-allocated
ListCell's actually reduced performance, according to these tests.
Dropping it to 4
16 matches
Mail list logo