Question : I have a column of type JSONB, where each row contains a JSON with an array of objects, […]
Tag: postgresql-10
Does PostgreSQL support ICU collation’s options and settings?
Question : ICU Specifies different LDML Collation Settings. Some of them seem pretty interesting, especially the ones on case and […]
Declaring variable for a whole script
Question : I have a PostgreSQL 10 script for which I would like to declare variables once at the beginning […]
Efficient pagination for big tables
Question : Using PostgreSQL 10.5. I’m trying to create a pagination system where the user can go back and forth […]
Suboptimal query plan when updating partitioned table
Question : Background I have a simple CTE used to update a declaratively-partitioned table. The subquery runs quickly (1.7sec per […]
Postgres jsonb complex query
Question : I have a table on PostgreSQL 10 that looks like: CREATE TABLE forms (id serial, form jsonb); INSERT […]
ORDER BY ASC is 300x faster than ORDER BY DESC
Question : The ascending sort is 300x faster than descending sort on a column which has a B-Tree index. I […]
Why are partial PostgreSQL HASH indices not smaller than full indices?
Question : I want to create the most efficient index for a sparsely populated column. I only need equality operations, […]
Remove characters from PostgreSQL database causing encoding errors
Question : I have a PostgreSQL 10 database that uses WIN1252 encoding. One of my columns has values that cause […]
Function accepts only certain passwords in postgreSQL
Question : I have created a function in a postgreSQL(v10.10) database to create new users or update existing ones. As […]