3 ms·
> A lot of processing jobs can't use indexes (except for lookup tables) so a PostgreSQL 4TB db with a schema for OLTP workloads doesn't solve the issue. What a
by bsg75 11y ago
> A lot of processing jobs can't use indexes (except for lookup tables) so a PostgreSQL 4TB db with a schema for OLTP workloads doesn't solve the issue.
What are the cases where an RDBMS can't use indexes on fact tables?
- sokoloff 11y agoSearching within fields is one example. WHERE street_address LIKE "%MAIN%ST%" WHERE xml_blob LIKE "%<deprecrated_feature_node_name%" to find documents that need to be updated when you remove that feature, etc. "Just use Mongo" or "just use the latest pgsql and convert to JSON" or "just do XYZ" is often a less practical answer than "just query/analyze the database you already have".
- usetrigram 11y agoIf you're using PostgreSQL you can just use a trigram index for these kinds of searches. - http://www.postgresql.org/docs/current/interactive/pgtrgm.html#AEN150325 http://www.postgresql.org/docs/current/interactive/pgtrgm.ht... - https://swtch.com/~rsc/regexp/regexp4.html https://swtch.com/~rsc/regexp/regexp4.html
- sokoloff 11y agoLOL at the new account name, but thank you very much for the pointer to an index type I didn't know existed!