User Gonzalo Vasquez

13

18

votes

2

answers

13k

views

Database “frozen” on ALTER TABLE

Mar 22 '16 at 20:15 jjanes 23.1k

4

12

votes

1

answer

22k

views

PostgreSQL: SSL SYSCALL error: EOF detected

postgresql postgresql-9.4 aws

Sep 24 '17 at 3:33 Community♦ 1

2

4

votes

2

answers

2k

views

Find unused indexes

postgresql index index-tuning postgresql-9.4

Nov 21 at 21:35 pncsoares 23

3

votes

2

answers

5k

views

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

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

Dec 14 '16 at 7:06 Raghu Sastry 11

1

3

votes

0

answers

872

views

Slony with Amazon's RDS service?

postgresql amazon-rds aws amazon-ec2 slony

Dec 18 '15 at 14:44 Gonzalo Vasquez 733

2

votes

1

answer

4k

views

ERROR: “sql ” is not a known variable

postgresql postgresql-9.4 scripting plpgsql unicode

Jun 13 '19 at 22:16 Erwin Brandstetter 121k

1

2

votes

2

answers

1k

views

Discover missing foreign keys and/or indexes

postgresql database-design index foreign-key

Oct 5 '18 at 15:56 Ask613 111

2

votes

2

answers

2k

views

Post Mortem Analysis: PostgreSQL replication failed

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

Jul 19 '17 at 16:19 Gonzalo Vasquez 733

2

votes

1

answer

625

views

PostgreSQL replication not working after base backup

postgresql replication linux postgresql-9.4 master-slave-replication

Jun 15 '17 at 5:50 sanyam jain 66

2

votes

0

answers

151

views

PostgreSQL database re-design considerations

postgresql database-design postgresql-9.4 inheritance

May 25 '17 at 13:56 Gonzalo Vasquez 733

2

votes

2

answers

3k

views

Where to look for possible deadlock causes?

postgresql postgresql-9.4 deadlock debugging

Mar 11 '16 at 17:16 Community♦ 1

2

votes

1

answer

441

views

Join query with different column types in “on” part

mysql join

Nov 27 '15 at 10:48 Andriy M 18.7k

1

vote

1

answer

116

views

Optimizing column types for reduced overall database size

postgresql schema postgresql-9.4 storage

Jan 19 '18 at 18:17 Gonzalo Vasquez 733

1

vote

1

answer

64

views

Selecting a proper data warehouse and/or big data approach

data-warehouse aws redshift

Apr 5 '17 at 9:32 Sir Swears-a-lot 2,822

1

vote

1

answer

7k

views

Adding array element to JSON column in PostgreSQL [duplicate]

postgresql update postgresql-9.4 json

Apr 4 '17 at 17:51 Community♦ 1

1

vote

1

answer

34

views

Finding time ranges in multiple rows

postgresql postgresql-9.4

May 11 '16 at 19:15 Community♦ 1

1

vote

0

answers

504

views

Inner join on array columns from 3 tables

postgresql join postgresql-9.4 array

Mar 25 '16 at 12:00 Gonzalo Vasquez 733

0

votes

1

answer

927

views

pg_restore: [archiver] could not find entry for ID 12

postgresql postgresql-9.4 pg-dump dump pg-restore

Jun 2 at 8:04 Community♦ 1

0

votes

3

answers

3k

views

Metrics for monitoring master-slave replication

postgresql replication postgresql-9.4 monitoring master-slave-replication

Dec 17 '18 at 13:33 derkan 21

0

votes

0

answers

24

views

Simple query rephrasing for optimization

postgresql optimization postgresql-9.4 explain

Feb 22 '18 at 18:18 Gonzalo Vasquez 733

0

votes

1

answer

39

views

New query taking over 60% of running time

postgresql optimization postgresql-9.4 explain

Feb 22 '18 at 18:08 a_horse_with_no_name 57.3k

0

votes

0

answers

187

views

Upgrading PostgreSQL 9.4.9 to 9.6.x on Debian

postgresql linux postgresql-9.4 upgrade postgresql-9.6

Oct 4 '17 at 13:57 Gonzalo Vasquez 733

0

votes

1

answer

513

views

Too much data queued in replication slots

postgresql replication postgresql-9.4 master-slave-replication

Sep 12 '17 at 17:21 jjanes 23.1k

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

Aug 4 '17 at 21:09 mustaccio 15.9k

0

votes

1

answer

107

views

Reclaiming unused indexes disk space

postgresql postgresql-9.4 statistics index-statistics

Mar 17 '17 at 0:45 gsiems 2,275

0

votes

0

answers

335

views

Comparing explain plains and execution time

postgresql optimization postgresql-9.4 explain

Mar 16 '17 at 15:06 a_horse_with_no_name 57.3k

0

votes

1

answer

93

views

Who deleted a record?

postgresql postgresql-9.4 audit

May 4 '16 at 13:42 TomTom 4,388

1

0

votes

1

answer

115

views

Missing / Orphan Indexes?

postgresql index postgresql-9.4

May 2 '16 at 15:41 a_horse_with_no_name 57.3k

0

votes

0

answers

2k

views

Cannot drop constraint due to FK references

postgresql foreign-key postgresql-9.4 constraint

May 2 '16 at 15:35 Gonzalo Vasquez 733

0

votes

0

answers

803

views

Query hung or way too long?

postgresql trigger postgresql-9.4 java

Mar 22 '16 at 13:32 Gonzalo Vasquez 733

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

34 Questions

Database “frozen” on ALTER TABLE

PostgreSQL: SSL SYSCALL error: EOF detected

Find unused indexes

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

Discover missing foreign keys and/or indexes

Post Mortem Analysis: PostgreSQL replication failed

PostgreSQL replication not working after base backup

PostgreSQL database re-design considerations

Where to look for possible deadlock causes?

Join query with different column types in “on” part

Optimizing column types for reduced overall database size

Selecting a proper data warehouse and/or big data approach

Adding array element to JSON column in PostgreSQL [duplicate]

Finding time ranges in multiple rows

Inner join on array columns from 3 tables

pg_restore: [archiver] could not find entry for ID 12

Metrics for monitoring master-slave replication

Simple query rephrasing for optimization

New query taking over 60% of running time

Upgrading PostgreSQL 9.4.9 to 9.6.x on Debian

Too much data queued in replication slots

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

Reclaiming unused indexes disk space

Comparing explain plains and execution time

Who deleted a record?

Missing / Orphan Indexes?

Cannot drop constraint due to FK references

Query hung or way too long?