Typo and random trivia about searchcraft HOT 5 CLOSED

@andyatkinson thanks; I didn't realised I forgot to write up about indexes so I've put some docs in #3

Unrelated, but I was in the swing of things, so #3 also starts to port over some solutions I have for text searching.

from searchcraft.

I personally cannot use the pg_ivm extension due to our constraints on our production host; but I can imagine supporting this alternate syntax SELECT create_immv('myview', 'SELECT * FROM mytab'); instead of CREATE MATERIALIZED VIEW myview AS SELECT * FROM mytab;. "How hard could it be?"

Currently the wrapper SQL for the MV is at

from searchcraft.

Thanks, yeah I haven't yet documented how to setup concurrent refreshes; nor documented how to add a new unique index column using the sequence that's already created for you. I've created #4 to track this.

from searchcraft.

@andyatkinson I appreciate your comments + questions + requests for better docs. Please let me know of any other ideas you have. I definitely don't know "all things MV".

from searchcraft.

@drnic Makes sense on the pg_ivm extension.

Also, re: indexes, passing on something else useful in case you didn't already know: refreshing a materialized view ideally is done "concurrently", so that other queries using it can continue to run while the results are replaced. Concurrent refreshes do require one unique index exists on the materialized view:

For here: https://github.com/drnic/searchcraft/blob/develop/lib/searchcraft/model.rb#L44

Docs on the concurrently keyword and unique index requirement: https://www.postgresql.org/docs/current/sql-refreshmaterializedview.html

from searchcraft.