User Gonzalo Vasquez

28 votes

2 answers

19k views

Database "frozen" on ALTER TABLE

asked Mar 21, 2016 at 13:28

13 votes

1 answer

38k views

PostgreSQL: SSL SYSCALL error: EOF detected

postgresql postgresql-9.4 aws

asked May 31, 2017 at 20:17

4 votes

2 answers

3k views

Find unused indexes

postgresql index index-tuning postgresql-9.4

asked May 2, 2016 at 16:48

4 votes

2 answers

5k views

Where to look for possible deadlock causes?

postgresql postgresql-9.4 deadlock debugging

asked Mar 7, 2016 at 15:54

3 votes

2 answers

6k views

org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery

postgresql postgresql-9.4 data-synchronization master-slave-replication

asked Dec 6, 2016 at 17:58

3 votes

0 answers

973 views

Slony with Amazon's RDS service?

postgresql amazon-rds aws amazon-ec2 slony

asked Dec 18, 2015 at 14:44

3 votes

1 answer

6k views

ERROR: "sql " is not a known variable

postgresql postgresql-9.4 scripting plpgsql unicode

asked Feb 7, 2018 at 19:35

2 votes

1 answer

1k views

PostgreSQL replication not working after base backup

postgresql replication linux postgresql-9.4 master-slave-replication

asked Mar 22, 2017 at 12:30

2 votes

2 answers

3k views

Post Mortem Analysis: PostgreSQL replication failed

postgresql replication postgresql-9.4 data-synchronization master-slave-replication

asked Jul 17, 2017 at 21:07

2 votes

0 answers

229 views

PostgreSQL database re-design considerations

postgresql database-design postgresql-9.4 inheritance

asked May 25, 2017 at 13:56

2 votes

2 answers

2k views

Discover missing foreign keys and/or indexes

postgresql database-design index foreign-key

asked Nov 24, 2015 at 15:07

2 votes

1 answer

849 views

Join query with different column types in "on" part

mysql join

asked Nov 24, 2015 at 13:38

1 vote

0 answers

4k views

Cannot drop constraint due to FK references

postgresql foreign-key postgresql-9.4 constraint

asked May 2, 2016 at 15:35

1 vote

0 answers

598 views

Inner join on array columns from 3 tables

postgresql join postgresql-9.4 array

asked Mar 25, 2016 at 12:00

1 vote

1 answer

40 views

Finding time ranges in multiple rows

postgresql postgresql-9.4

asked May 11, 2016 at 17:55

1 vote

1 answer

69 views

Selecting a proper data warehouse and/or big data approach

data-warehouse aws redshift

asked Apr 3, 2017 at 15:53

1 vote

1 answer

8k views

Adding array element to JSON column in PostgreSQL [duplicate]

postgresql update postgresql-9.4 json

asked Apr 4, 2017 at 17:14

1 vote

1 answer

752 views

Too much data queued in replication slots

postgresql replication postgresql-9.4 master-slave-replication

asked Sep 12, 2017 at 12:47

1 vote

1 answer

151 views

Optimizing column types for reduced overall database size

postgresql schema postgresql-9.4 storage

asked Jan 19, 2018 at 12:36

0 votes

0 answers

202 views

Upgrading PostgreSQL 9.4.9 to 9.6.x on Debian

postgresql linux postgresql-9.4 upgrade postgresql-9.6

asked Oct 4, 2017 at 13:57

0 votes

1 answer

44 views

New query taking over 60% of running time

postgresql optimization postgresql-9.4 explain

asked Feb 22, 2018 at 15:36

0 votes

0 answers

28 views

Simple query rephrasing for optimization

postgresql optimization postgresql-9.4 explain

asked Feb 22, 2018 at 17:32

0 votes

1 answer

132 views

Who deleted a record?

postgresql postgresql-9.4 audit

asked May 4, 2016 at 13:24

0 votes

1 answer

5k views

Database Wrapper Design issue: No operator matches the given name and argument type(s)

postgresql postgresql-9.4 aws java jdbc

asked Aug 4, 2017 at 19:47

0 votes

1 answer

156 views

Missing / Orphan Indexes?

postgresql index postgresql-9.4

asked May 2, 2016 at 15:28

0 votes

3 answers

3k views

Metrics for monitoring master-slave replication

postgresql replication postgresql-9.4 monitoring master-slave-replication

asked Dec 7, 2016 at 13:18

0 votes

0 answers

340 views

Comparing explain plains and execution time

postgresql optimization postgresql-9.4 explain

asked Mar 16, 2017 at 14:22

0 votes

1 answer

120 views

Reclaiming unused indexes disk space

postgresql postgresql-9.4 statistics index-statistics

asked Mar 17, 2017 at 0:08

0 votes

1 answer

1k views

Join query with closest date in "ON" clause

mysql join

asked Nov 24, 2015 at 14:36

0 votes

1 answer

206 views

Improve performance of query with many joins

postgresql index index-tuning performance postgresql-performance

asked Nov 16, 2015 at 14:51

Stack Exchange Network

current community

your communities

more stack exchange communities

33 Questions

Database "frozen" on ALTER TABLE

PostgreSQL: SSL SYSCALL error: EOF detected

Find unused indexes

Where to look for possible deadlock causes?

org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery

Slony with Amazon's RDS service?

ERROR: "sql " is not a known variable

PostgreSQL replication not working after base backup

Post Mortem Analysis: PostgreSQL replication failed

PostgreSQL database re-design considerations

Discover missing foreign keys and/or indexes

Join query with different column types in "on" part

Cannot drop constraint due to FK references

Inner join on array columns from 3 tables

Finding time ranges in multiple rows

Selecting a proper data warehouse and/or big data approach

Adding array element to JSON column in PostgreSQL [duplicate]

Too much data queued in replication slots

Optimizing column types for reduced overall database size

Upgrading PostgreSQL 9.4.9 to 9.6.x on Debian

New query taking over 60% of running time

Simple query rephrasing for optimization

Who deleted a record?

Database Wrapper Design issue: No operator matches the given name and argument type(s)

Missing / Orphan Indexes?

Metrics for monitoring master-slave replication

Comparing explain plains and execution time

Reclaiming unused indexes disk space

Join query with closest date in "ON" clause

Improve performance of query with many joins