User Gajus

1 vote

0 answers

2k views

Optimal index for storing crypto addresses using bytea

asked May 31, 2021 at 23:57

1 vote

1 answer

27 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 at 18:35

0 votes

0 answers

30 views

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

asked Jan 20 at 23:14

2 votes

0 answers

191 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

4 votes

1 answer

432 views

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

asked Oct 21, 2022 at 18:01

0 votes

0 answers

54 views

How are the exclusions handled in RBAC design?

asked Oct 7, 2022 at 2:57

0 votes

0 answers

72 views

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

asked Sep 11, 2022 at 23:37

4 votes

1 answer

309 views

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

asked Dec 31, 2018 at 14:18

8 votes

3 answers

5k views

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

asked May 31, 2018 at 12:58

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

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

8 votes

2 answers

1k views

How can I find the shortest path between two currencies?

asked May 18, 2021 at 2:14

1 vote

1 answer

571 views

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

asked Feb 11, 2021 at 22:50

1 vote

1 answer

46 views

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

asked Jan 8, 2021 at 11:36

3 votes

3 answers

4k views

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

asked Dec 31, 2018 at 10:55

0 votes

0 answers

185 views

How to group by similar full-text?

asked Feb 17, 2020 at 5:52

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

142 views

How to find similar records using multidimensional array?

asked Sep 26, 2019 at 20:54

0 votes

1 answer

51 views

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

asked Aug 15, 2019 at 12:33

4 votes

1 answer

1k views

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

asked Jul 3, 2019 at 16:45

1 vote

2 answers

1k views

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

asked Mar 3, 2019 at 12:46

3 votes

2 answers

3k views

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

asked Jan 11, 2019 at 12:03

0 votes

0 answers

87 views

How to partition a table without time data?

asked Jan 8, 2019 at 11:09

5 votes

2 answers

3k views

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

asked Dec 9, 2018 at 11:06

1 vote

1 answer

285 views

How to get row_number() within a group?

asked Aug 12, 2018 at 19:57

2 votes

2 answers

8k views

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

asked May 29, 2018 at 19:37

5 votes

3 answers

6k views

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

asked May 18, 2018 at 0:00

0 votes

1 answer

345 views

Does SKIP LOCKED FOR UPDATE work with views?

asked May 19, 2018 at 11:17

2 votes

4 answers

2k views

How to conditionally append rows to a result set?

asked May 13, 2018 at 10:33

1 vote

3 answers

719 views

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

asked May 6, 2018 at 10:25

Stack Exchange Network

34 Questions

Optimal index for storing crypto addresses using bytea

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

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

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

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

How are the exclusions handled in RBAC design?

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

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

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

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

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

How can I find the shortest path between two currencies?

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

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

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

How to group by similar full-text?

How to write a no-op UPDATE query?

How to find similar records using multidimensional array?

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

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

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

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

How to partition a table without time data?

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

How to get row_number() within a group?

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

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

Does SKIP LOCKED FOR UPDATE work with views?

How to conditionally append rows to a result set?

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