Question : For every version of Postgres that supported hash indexing, there is a warning or note that hash indexes […]
Tag: hashing
In PostgreSQL, what area in memory does HashSetOp use, work_mem or shared_buffer?
Question : I want to know the difference between the hash table in a hash join and the hash table […]
Conflict resolution for hash-backed unique constraint of large text bodies
Question : So we’ve just run into ERROR: index row size 2736 exceeds maximum 2712 for index “foo__bar__un” Hint: Values […]
Conflict resolution for hash-backed unique constraint of large text bodies
Question : So we’ve just run into ERROR: index row size 2736 exceeds maximum 2712 for index “foo__bar__un” Hint: Values […]
SQL Server hashbytes seed
Question : I’m trying to compare hashes generated by SQL Server HASHBYTES() with hashes generated with python’s hash() (or hashlib) […]
Index of which columns are NOT empty
Question : I am trying to enhance the search performance of a table based on whether certain columns contain values. […]
Insert PBKDF2 hash into PostgreSQL container
Question : I am using the PostgreSQL docker image with the following Dockerfile: FROM postgres:10.1 COPY init-db.sh /docker-entrypoint-initdb.d/init-db.sh and an […]
PostgreSQL: what are purpose of functions uuid_hash(uuid) and uuid_hash_extended(uuid, bigint)
Question : Functions uuid_hash and uuid_hash_extended Exploring postgresql I discovered 2 functions that looks interesting: SELECT p.proname , obj_description(p.oid) AS […]
Specify build and probe tables to hash join?
Question : I am observing a situation in AdventureWorks database where the hash join operator is building hash table using […]
Best Data Type to Store Result of HASHBYTES(‘MD5’, …)
Question : What would be the best data type to store the results of the HASHBYTES(‘MD5’, …)? It outputs 16 […]