Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Gajus's user avatar
Gajus's user avatar
Gajus's user avatar
Gajus
  • Member for 11 years, 8 months
  • Last seen this week
9 votes
3 answers
7k views

How to check if the current connection is in a transaction?

9 votes
2 answers
1k views

How can I find the shortest path between two currencies?

6 votes
1 answer
2k views

How to check if int[] array contains a value less than X?

5 votes
2 answers
3k views

How to optimize a table for a very high-frequency updates?

5 votes
3 answers
7k views

How do I round time to the upper multiple of an arbitrary time interval?

4 votes
1 answer
336 views

How to get query output in addition to EXPLAIN ANALYZE output?

4 votes
1 answer
566 views

Does it make sense to split an often updated column into a separate table?

4 votes
1 answer
1k views

How to run EXPLAIN ANALYZE and get results of the query?

3 votes
2 answers
3k views

Containment check tstzrange @> timestamptz not using btree or gist index

3 votes
3 answers
5k views

How to check if the current time is between two times?

3 votes
1 answer
3k views

Percona Node fails to join: Operation not permitted

2 votes
4 answers
3k views

How to conditionally append rows to a result set?

2 votes
2 answers
8k views

How to use FOR UPDATE with a view that is built using LEFT JOIN?

2 votes
0 answers
248 views

How to debug why a cascading delete from a foreign key constraint is taking a long time?

1 vote
1 answer
73 views

Does it make sense to prefer jsonb data type over text[] even if I am only planning to store text array?

1 vote
0 answers
2k views

Optimal index for storing crypto addresses using bytea

1 vote
2 answers
2k views

How to get N rows after the first row matching a condition?

1 vote
1 answer
57 views

How to check if a column in a query can produce NULL?

1 vote
1 answer
671 views

What is the benefit of marking function as IMMUTABLE? [duplicate]

1 vote
1 answer
303 views

How to get row_number() within a group?

1 vote
0 answers
178 views

What is the smallest encoding?

1 vote
1 answer
3k views

What is the fastest way to insert data into MySQL memory table?

1 vote
0 answers
125 views

How to profile individual queries using PERFORMANCE_SCHEMA

1 vote
3 answers
766 views

Is there a way to include an assertion about the expected number of rows?

0 votes
1 answer
396 views

Does SKIP LOCKED FOR UPDATE work with views?

0 votes
1 answer
138 views

What is the correct way to select data grouped by time interval?

0 votes
0 answers
87 views

How to partition a table without time data?

0 votes
2 answers
3k views

How to write a no-op UPDATE query?

0 votes
1 answer
55 views

How to design a table/ unique index where uniqueness is temporal?

0 votes
1 answer
149 views

How to find similar records using multidimensional array?