Skip to main content
Database Administrators
cis's user avatar
cis's user avatar
cis's user avatar
cis
  • Member for 8 years, 3 months
  • Last seen more than a month ago
Profile Activity
Stats
469
reputation
22k
reached
2
answers
11
questions
Communities
View all
About

Web Developer and DevOps. I like to model reality into software: Structure the data, then make it flow the way I want. Code it, deploy it, maintain it - however complex it might become. I have a background in humanities (medieval history).

Badges
View all badges
This user doesn’t have any gold badges yet.
5
silver badges
19
bronze badges
Top tags
View all tags
10
Score
5
Posts
38
Posts %
10
Score
5
Posts
38
Posts %
10
Score
4
Posts
31
Posts %
7
Score
10
Posts
77
Posts %
7
Score
2
Posts
15
Posts %
3
Score
2
Posts
15
Posts %
Top posts
View all questions and answers
question
11
Do I need an explicit FOR UPDATE lock in a CTE in UPDATE?
Mar 14, 2022
question
7
Recursive CTE based on function values significantly slower on Postgres 12 than on 11
Jan 20, 2020
answer
7
Recursive CTE based on function values significantly slower on Postgres 12 than on 11
Jan 30, 2020
question
6
Upgrade from Postgres 11 to Postgres 12 made some queries 300x slower, probably due to new CTE handling
Jan 13, 2020
answer
3
Upgrade from Postgres 11 to Postgres 12 made some queries 300x slower, probably due to new CTE handling
Jan 30, 2020
question
2
Postgres query cache analyzing table basis?
Oct 25, 2017
question
2
WHERE clause not preventing return of row but changing values for aggregate function (here: count)
Feb 13, 2020
question
1
Sequence: last_value billions bigger that actual count of rows
Jul 16, 2018
question
1
Returning in query whether a column has been changed by the current query or not
Mar 8, 2022
question
0
mongoDB: Limit user to find documents only by ObjectId
May 15, 2019
Top network posts
View all network posts
23
Is allowing blob: in Content-Security-Policy a risk?
12
Prevent overlapping while positioning element at height of another
11
Non existing property: EventEmitter memory error instead of proper error message
10
How to ensure data consistency in system with multiple databases?
7
Name for exploratory "role play" testing?