Skip to main content
Database Administrators
John Bachir's user avatar
John Bachir's user avatar
John Bachir's user avatar
John Bachir
  • Member for 12 years, 3 months
  • Last seen more than a month ago
Profile Activity
Stats
827
reputation
107k
reached
7
answers
22
questions
Communities
About

Formerly CTO at Freedom, Co-Founder & CTO at Medstro.

Badges
View all badges
1
gold badge
12
silver badges
28
bronze badges
Top tags
View all tags
20
Score
27
Posts
93
Posts %
20
Score
14
Posts
48
Posts %
2
Score
3
Posts
10
Posts %
2
Score
2
Posts
7
Posts %
1
Score
3
Posts
10
Posts %
0
Score
4
Posts
14
Posts %
Top posts
View all questions and answers
question
15
How can I set a column to NOT NULL without locking the table during a table scan?
May 27, 2020
question
12
Why am I getting a deadlock for a single UPDATE query?
Jan 12, 2020
answer
11
Find unused indexes
Nov 21, 2019
question
5
What type of locks are needed when creating a Postgres index concurrently?
Nov 24, 2020
question
4
Which index type is best suited for exact-match against a list of values?
Mar 31, 2018
answer
4
How can I determine why a concurrent Postgres index was marked as INVALID?
Nov 21, 2019
question
3
How should I represent a midnight end time?
Mar 7, 2018
question
3
How can I lock rows FOR UPDATE without returning data over the connection?
Jan 12, 2020
question
2
How does Postgres handle integer data of different sizes in the same column?
Jun 19, 2017
question
2
How can I set a default now() timestamp in a timestamp array?
Dec 30, 2017