User Gajus

10 votes

3 answers

8k views

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

asked May 31, 2018 at 12:58

9 votes

2 answers

1k views

How can I find the shortest path between two currencies?

asked May 18, 2021 at 2:14

6 votes

1 answer

2k views

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

asked Dec 1, 2021 at 1:16

5 votes

2 answers

3k views

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

asked Dec 9, 2018 at 11:06

5 votes

3 answers

7k views

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

asked May 18, 2018 at 0:00

4 votes

1 answer

350 views

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

asked Dec 31, 2018 at 14:18

4 votes

1 answer

686 views

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

asked Oct 21, 2022 at 18:01

4 votes

1 answer

2k views

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

asked Jul 3, 2019 at 16:45

3 votes

2 answers

3k views

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

asked Jan 11, 2019 at 12:03

3 votes

3 answers

5k views

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

asked Dec 31, 2018 at 10:55

3 votes

1 answer

3k views

Percona Node fails to join: Operation not permitted

asked May 21, 2013 at 7:44

2 votes

4 answers

3k views

How to conditionally append rows to a result set?

asked May 13, 2018 at 10:33

2 votes

2 answers

9k views

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

asked May 29, 2018 at 19:37

2 votes

0 answers

294 views

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

asked Nov 10, 2022 at 14:25

1 vote

1 answer

111 views

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

asked Jan 23, 2023 at 18:35

1 vote

0 answers

2k views

Optimal index for storing crypto addresses using bytea

asked May 31, 2021 at 23:57

1 vote

2 answers

2k views

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

asked Mar 3, 2019 at 12:46

1 vote

1 answer

58 views

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

asked Jan 8, 2021 at 11:36

1 vote

1 answer

721 views

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

asked Feb 11, 2021 at 22:50

1 vote

1 answer

321 views

How to get row_number() within a group?

asked Aug 12, 2018 at 19:57

1 vote

0 answers

182 views

What is the smallest encoding?

asked Aug 29, 2013 at 12:36

1 vote

1 answer

3k views

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

asked May 16, 2016 at 19:17

1 vote

0 answers

125 views

How to profile individual queries using PERFORMANCE_SCHEMA

asked Sep 16, 2012 at 11:41

1 vote

3 answers

794 views

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

asked May 6, 2018 at 10:25

0 votes

1 answer

447 views

Does SKIP LOCKED FOR UPDATE work with views?

asked May 19, 2018 at 11:17

0 votes

1 answer

157 views

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

asked May 3, 2018 at 21:12

0 votes

0 answers

90 views

How to partition a table without time data?

asked Jan 8, 2019 at 11:09

0 votes

2 answers

3k views

How to write a no-op UPDATE query?

asked Mar 26, 2019 at 18:16

0 votes

1 answer

57 views

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

asked Aug 15, 2019 at 12:33

0 votes

1 answer

150 views

How to find similar records using multidimensional array?

asked Sep 26, 2019 at 20:54

Stack Exchange Network

34 Questions

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

How can I find the shortest path between two currencies?

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

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

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

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

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

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

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

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

Percona Node fails to join: Operation not permitted

How to conditionally append rows to a result set?

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

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

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

Optimal index for storing crypto addresses using bytea

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

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

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

How to get row_number() within a group?

What is the smallest encoding?

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

How to profile individual queries using PERFORMANCE_SCHEMA

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

Does SKIP LOCKED FOR UPDATE work with views?

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

How to partition a table without time data?

How to write a no-op UPDATE query?

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

How to find similar records using multidimensional array?