User Gonzalo Vasquez

11

12

votes

2

answers

9k

views

Database “frozen” on ALTER TABLE

Mar 22 '16 at 20:15 jjanes 18.2k

2

9

votes

1

answer

14k

views

PostgreSQL: SSL SYSCALL error: EOF detected

postgresql postgresql-9.4 aws

Sep 24 '17 at 3:33 Community♦ 1

3

votes

0

answers

768

views

Slony with Amazon's RDS service?

postgresql amazon-rds aws amazon-ec2 slony

Dec 18 '15 at 14:44 Gonzalo Vasquez 373

2

votes

1

answer

3k

views

ERROR: “sql ” is not a known variable

postgresql postgresql-9.4 scripting plpgsql unicode

Jun 13 at 22:16 Erwin Brandstetter 105k

1

2

votes

2

answers

991

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

1k

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 373

2

votes

1

answer

336

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

116

views

PostgreSQL database re-design considerations

postgresql database-design postgresql-9.4 inheritance

May 25 '17 at 13:56 Gonzalo Vasquez 373

2

votes

2

answers

4k

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

2

votes

2

answers

2k

views

Where to look for possible deadlock causes?

postgresql postgresql-9.4 deadlock debugging

Mar 11 '16 at 17:16 Gonzalo Vasquez 373

2

votes

1

answer

262

views

Join query with different column types in “on” part

mysql join

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

1

vote

1

answer

108

views

Optimizing column types for reduced overall database size

postgresql schema postgresql-9.4 storage

Jan 19 '18 at 18:17 Gonzalo Vasquez 373

1

vote

1

answer

58

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,344

1

vote

1

answer

4k

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

2

1

vote

1

answer

1k

views

Find unused indexes

postgresql index index-tuning postgresql-9.4

May 3 '16 at 1:54 Peter Eisentraut 7,957

1

vote

0

answers

487

views

Inner join on array columns from 3 tables

postgresql join postgresql-9.4 array

Mar 25 '16 at 12:00 Gonzalo Vasquez 373

0

votes

1

answer

594

views

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

postgresql postgresql-9.4 pg-dump dump pg-restore

Sep 16 at 6:00 Community♦ 1

0

votes

3

answers

2k

views

Metrics for monitoring master-slave replication

postgresql replication postgresql-9.4 monitoring master-slave-replication

Dec 17 at 13:33 derkan 11

0

votes

0

answers

21

views

Simple query rephrasing for optimization

postgresql optimization postgresql-9.4 explain

Feb 22 '18 at 18:18 Gonzalo Vasquez 373

0

votes

1

answer

38

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 47.2k

0

votes

0

answers

166

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 373

0

votes

1

answer

418

views

Too much data queued in replication slots

postgresql replication postgresql-9.4 master-slave-replication

Sep 12 '17 at 17:21 jjanes 18.2k

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 12.4k

0

votes

1

answer

87

views

Reclaiming unused indexes disk space

postgresql postgresql-9.4 statistics index-statistics

Mar 17 '17 at 0:45 gsiems 1,905

0

votes

0

answers

303

views

Comparing explain plains and execution time

postgresql optimization postgresql-9.4 explain

Mar 16 '17 at 15:06 a_horse_with_no_name 47.2k

0

votes

1

answer

79

views

Who deleted a record?

postgresql postgresql-9.4 audit

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

1

0

votes

1

answer

93

views

Missing / Orphan Indexes?

postgresql index postgresql-9.4

May 2 '16 at 15:41 a_horse_with_no_name 47.2k

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 373

0

votes

0

answers

638

views

Query hung or way too long?

postgresql trigger postgresql-9.4 java

Mar 22 '16 at 13:32 Gonzalo Vasquez 373

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

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

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

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

Find unused indexes

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?