Skip to main content
Gajus's user avatar
Gajus's user avatar
Gajus's user avatar
Gajus
  • Member for 11 years, 10 months
  • Last seen this week
1 vote
1 answer
90 views

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

0 votes
0 answers
30 views

Is calling a stable function performance comparable to reading values from a table?

2 votes
0 answers
271 views

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

4 votes
1 answer
627 views

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

0 votes
0 answers
55 views

How are the exclusions handled in RBAC design?

0 votes
0 answers
89 views

How to design a database table(s) for recording email changes?

6 votes
1 answer
2k views

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

1 vote
0 answers
2k views

Optimal index for storing crypto addresses using bytea

9 votes
2 answers
1k views

How can I find the shortest path between two currencies?

1 vote
1 answer
700 views

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

1 vote
1 answer
57 views

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

0 votes
0 answers
217 views

How to group by similar full-text?

0 votes
1 answer
149 views

How to find similar records using multidimensional array?

0 votes
1 answer
56 views

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

4 votes
1 answer
1k views

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

0 votes
2 answers
3k views

How to write a no-op UPDATE query?

1 vote
2 answers
2k views

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

3 votes
2 answers
3k views

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

0 votes
0 answers
88 views

How to partition a table without time data?

4 votes
1 answer
345 views

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

3 votes
3 answers
5k views

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

5 votes
2 answers
3k views

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

1 vote
1 answer
314 views

How to get row_number() within a group?

9 votes
3 answers
8k views

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

2 votes
2 answers
9k views

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

0 votes
1 answer
424 views

Does SKIP LOCKED FOR UPDATE work with views?

5 votes
3 answers
7k views

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

2 votes
4 answers
3k views

How to conditionally append rows to a result set?

1 vote
3 answers
774 views

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

0 votes
1 answer
147 views

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