Question : psql (11.8) Type “help” for help. public=# select ‘!@#$%^&*()00:00:00.01<>?<>:’::interval; interval ————- 00:00:00.01 (1 row) Seems to take just […]
Postgres: why did this trigram index slow down regexp queries?
Question : I have a TEXT keyvalues column in Postgres: select * from test5 limit 5; id | keyvalues —-+—————————————————— […]
Installation of PostgreSQL-11: Depends: libllvm6.0 (>= 1:6.0~svn298832-1~) but it is not installable
Question : I’ve added the official repository to my sources.list, deb http://apt.postgresql.org/pub/repos/apt/ cosmic-pgdg main 11 When I try to install […]
What SQL execution time should I expect when querying 4k records in a 150M records table?
Question : We currently have performance issues with a SQL query on RDS Postgres 11.8. Here is the query: SELECT […]
Using activity over last few days to label user as “active”
Question : Here’s an example dataset. with activity_cte (day, user_id, act1, act2) as ( values (‘2020-01-01’::date, 1, 0, 1), (‘2020-01-01’::date, […]
How to set statement timeout per user?
Question : I have multiple users in Postgres. I would like to set up different statement timeouts for different users. […]
Recommended procedure to remove old files after major version PostgreSQL database cluster upgrade
Question : I (successfully) followed the upgrade procedure in §18.6.1 of the PostgreSQL Manual to upgrade a PostgreSQL database cluster […]
Postgresql (11.9) LIKE query not using text_ops index
Question : I’ve seen related questions but I think this should be working and isn’t. I have a text_ops function […]
PostgreSQL Index Only Scan can NOT return ctid
Question : I have this table in PostgreSQL 11: CREATE TABLE A (id bigint PRIMARY KEY, text text) Now I […]
How to check if a value is in an array in a table
Question : I have a table if key – array pairs and need to check if a string is an […]