wal-check: temp-install

$(prove_check)

As a reward for your reformation I write to you on this precious sheet.

You see I have come to be wonderfully attached to Heidelberg, the

beautiful, the quaint, the historically poetic, learned and picturesque

old town on the Neckar. It seems like another home. So I could not show

my appreciation of you in a more complimentary way than by sending this

little series of pictures. Have you ever been here, I wonder? You did

not say, but you wrote as if you knew it by sight as well as by heart.

As I cannot know, I will venture an explanation. The panorama speaks for

itself. Put on your “specs” and look at the castle, half way up the

_berg_, “the Jettenhuhl, a wooded spur of the Konigestuhl.” Look at it

from the “Terrasse.” Thus you’ll get something of an idea of it. The

Gesprente Thurm is the one that was blown up by the French. The

thickness of the walls, twenty-one feet, and the solid masonry, held it

so well that only a fragment, as it were, gave way. It still hangs as if

ready to be replaced. “Das Grosse Fass Gebaude,” too, you will have no

difficulty in making out. If you only had it with its 49,000 gallons of

wine, but wouldn’t you divide with your neighbors! The columns in the

portico that shows in the Schlosshof are the four brought from

Charlemagne’s palace at Ingelheim by the Count Palatine Ludwig, some

time between 1508-44. The Zum Ritter has nothing to do with the castle,

but is an ancient structure (1592) in the Renaissance style, and one of

the few that escaped destruction in 1693. It is a beautiful, highly

ornamental building, and I wish you could see it, if you have not seen

it.

All the above information, I beg you to believe, I do not intend you

to think was evolved from my inner consciousness, but gathered from

the--nearest guide-book!

I am so much obliged to you for mapping out Switzerland to me. I have

been trying my best to get all those “passes” into my brain. Now, thanks

to your letter, I have them all in the handiest kind of a bunch. Ariel

like, “I’ll do my bidding gently,” and as surely, if I get there. But

there are dreadful reports of floods and roads caved in and bridges

swept away and snows and--enough of such exciting items as sets one

thinking--“to go or not to go?” We are this far on the way. Reached

here this afternoon. Have spent the evening sauntering in the gardens,

the Conversationhaus, the bazaar, mingling with the throng, listening to

the band, and comparing what it is with what it was. It was a gay and

curious spectacle, but on the whole had “the banquet-hall deserted”

look. The situation is most beautiful. It lies, you know, at the

entrance of the Black Forest, among picturesque, thickly-wooded hills,

in the valley of the Oos, and extends up the slope of some of the hills.

The Oos is a most turbid, turbulent stream; dashes through part of the

town with angry, headlong speed. There is an avenue along its bank of

oaks, limes and maples, bordered with flower-beds and shrubberies, and

adorned with fountains and handsome villas. We shall devote to-morrow to

seeing all there is to be seen, and go to Strassburg to-morrow evening

for two or three days. From there to Constance, and then hold _our_

“Council” as to further movements.

CREATE EXTENSION rum;

CREATE TABLE test_rum( t text, a tsvector );

CREATE TRIGGER tsvectorupdate

BEFORE UPDATE OR INSERT ON test_rum

FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a', 'pg_catalog.english', 't');

CREATE INDEX rumidx ON test_rum USING rum (a rum_tsvector_ops);

\copy test_rum(t) from 'data/rum.data';

SET enable_seqscan=off;

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'ever|wrote');

count

-------

2

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'have&wish');

count

-------

1

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'knew&brain');

count

-------

0

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'among');

count

-------

1

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'structure&ancient');

count

-------

1

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', '(complimentary|sight)&(sending|heart)');

count

-------

2

(1 row)

INSERT INTO test_rum (t) VALUES ('foo bar foo the over foo qq bar');

INSERT INTO test_rum (t) VALUES ('345 qwerty copyright');

INSERT INTO test_rum (t) VALUES ('345 qwerty');

INSERT INTO test_rum (t) VALUES ('A fat cat has just eaten a rat.');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar');

count

-------

1

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'qwerty&345');

count

-------

2

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', '345');

count

-------

2

(1 row)

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'rat');

count

-------

1

(1 row)

SELECT a FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar') ORDER BY a;

a

------------------------------

'bar':2,8 'foo':1,3,6 'qq':7

(1 row)

DELETE FROM test_rum;

SELECT count(*) from test_rum;

count

-------

0

(1 row)

CREATE EXTENSION rum;

CREATE TABLE test_rum( t text, a tsvector );

CREATE TRIGGER tsvectorupdate

BEFORE UPDATE OR INSERT ON test_rum

FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a', 'pg_catalog.english', 't');

CREATE INDEX rumidx ON test_rum USING rum (a rum_tsvector_ops);

\copy test_rum(t) from 'data/rum.data';

SET enable_seqscan=off;

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'ever|wrote');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'have&wish');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'knew&brain');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'among');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'structure&ancient');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', '(complimentary|sight)&(sending|heart)');

INSERT INTO test_rum (t) VALUES ('foo bar foo the over foo qq bar');

INSERT INTO test_rum (t) VALUES ('345 qwerty copyright');

INSERT INTO test_rum (t) VALUES ('345 qwerty');

INSERT INTO test_rum (t) VALUES ('A fat cat has just eaten a rat.');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'qwerty&345');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', '345');

SELECT count(*) FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'rat');

SELECT a FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'bar') ORDER BY a;

DELETE FROM test_rum;

SELECT count(*) from test_rum;

use strict;

use warnings;

use PostgresNode;

use TestLib;

use Test::More tests => 31;

my $node_master;

my $node_standby;

sub test_index_replay

{

my ($test_name) = @_;

# Wait for standby to catch up

my $applname = $node_standby->name;

my $caughtup_query =

"SELECT pg_current_xlog_location() <= write_location FROM pg_stat_replication WHERE application_name = '$applname';";

$node_master->poll_query_until('postgres', $caughtup_query)

or die "Timed out while waiting for standby 1 to catch up";

my $queries = qq(SET enable_seqscan=off;

);

# Run test queries and compare their result

my $master_result = $node_master->psql("postgres", $queries);

my $standby_result = $node_standby->psql("postgres", $queries);

is($master_result, $standby_result, "$test_name: query result matches");

}

$node_master = get_new_node('master');

$node_master->init(allows_streaming => 1);

$node_master->start;

my $backup_name = 'my_backup';

$node_master->backup($backup_name);

$node_standby = get_new_node('standby');

$node_standby->init_from_backup($node_master, $backup_name,

has_streaming => 1);

$node_standby->start;

$node_master->psql("postgres", "CREATE EXTENSION rum;");

$node_master->psql("postgres", "CREATE TABLE tst (i int4, t tsvector);");

$node_master->psql("postgres", "INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(1,100000) i;");

$node_master->psql("postgres", "CREATE INDEX rumidx ON tst USING rum (t rum_tsvector_ops);");

test_index_replay('initial');

for my $i (1..10)

{

$node_master->psql("postgres", "DELETE FROM tst WHERE i = $i;");

test_index_replay("delete $i");

$node_master->psql("postgres", "VACUUM tst;");

test_index_replay("vacuum $i");

my ($start, $end) = (100001 + ($i - 1) * 10000, 100000 + $i * 10000);

$node_master->psql("postgres", "INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series($start,$end) i;");

test_index_replay("insert $i");

}