User Morris de Oryx

16 votes

Should I not use camelCase in my column names?

answered Oct 13, 2019 at 9:52

7 votes

Accepted

PostgreSQL naming conventions

answered Aug 18, 2019 at 11:27

2 votes

Why should foreign keys be implemented in my relational database?

answered Aug 20, 2019 at 1:35

2 votes

Create event trigger as non-superuser in Postgres

answered Aug 30, 2019 at 1:19

2 votes

Accepted

Multidimensional pivot in postgres without crosstabs

answered Nov 6, 2019 at 4:12

2 votes

Is it a good or bad idea to use "ON UPDATE CASCADE ON DELETE CASCADE" for foreign keys? Why does this mechanism exist at all?

answered Dec 3, 2019 at 6:29

1 vote

Is there some sort of shortcut/feature in PostgreSQL to avoid horrible storage waste with duplicate values?

answered Dec 3, 2019 at 7:52

1 vote

PostgreSQL NOT IN array slow query

answered Nov 12, 2019 at 20:27

1 vote

Postgresql extremely slow count (with index, simple query)

answered Aug 22, 2019 at 23:56

1 vote

Best Way To Create Time Series from Postgres Table Update History?

answered Jul 9, 2019 at 12:42

1 vote

How to speed up Oracle to PostgreSQL data transfer

answered Jul 26, 2019 at 23:32

1 vote

MADlib apply `cosine_similarity` on term frequency

answered Sep 25, 2019 at 10:04

0 votes

Improving the queries in a view to query custom types

answered Aug 27, 2019 at 9:22

0 votes

PostgreSQL: cast row to type

answered Sep 7, 2019 at 21:38

0 votes

Most efficient way to insert data into archiving table without influencing production?

answered Sep 11, 2019 at 6:58

0 votes

Expression index on a citext column ignored, why?

answered Sep 19, 2019 at 12:39

0 votes

Query for similar syllables on a field

answered Nov 21, 2019 at 11:18

0 votes

Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?

answered Dec 5, 2019 at 4:58

0 votes

PostgreSQL: Is it possible to get a different function result type (i.e. TABLE) in stored function based on input?

answered Dec 13, 2019 at 7:04

Stack Exchange Network

19 Answers

Should I not use camelCase in my column names?

PostgreSQL naming conventions

Why should foreign keys be implemented in my relational database?

Create event trigger as non-superuser in Postgres

Multidimensional pivot in postgres without crosstabs

Is it a good or bad idea to use "ON UPDATE CASCADE ON DELETE CASCADE" for foreign keys? Why does this mechanism exist at all?

Is there some sort of shortcut/feature in PostgreSQL to avoid horrible storage waste with duplicate values?

PostgreSQL NOT IN array slow query

Postgresql extremely slow count (with index, simple query)

Best Way To Create Time Series from Postgres Table Update History?

How to speed up Oracle to PostgreSQL data transfer

MADlib apply `cosine_similarity` on term frequency

Improving the queries in a view to query custom types

PostgreSQL: cast row to type

Most efficient way to insert data into archiving table without influencing production?

Expression index on a citext column ignored, why?

Query for similar syllables on a field

Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?

PostgreSQL: Is it possible to get a different function result type (i.e. TABLE) in stored function based on input?