Gonzalo Vasquez's user avatar
Gonzalo Vasquez's user avatar
Gonzalo Vasquez's user avatar
Gonzalo Vasquez
  • Member for 6 years, 10 months
  • Last seen more than 1 year ago
28 votes
2 answers
20k views

Database "frozen" on ALTER TABLE

14 votes
1 answer
40k views

PostgreSQL: SSL SYSCALL error: EOF detected

4 votes
2 answers
3k views

Find unused indexes

4 votes
2 answers
5k views

Where to look for possible deadlock causes?

3 votes
2 answers
6k views

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

3 votes
0 answers
976 views

Slony with Amazon's RDS service?

3 votes
1 answer
6k views

ERROR: "sql " is not a known variable

2 votes
1 answer
1k views

PostgreSQL replication not working after base backup

2 votes
2 answers
3k views

Post Mortem Analysis: PostgreSQL replication failed

2 votes
0 answers
234 views

PostgreSQL database re-design considerations

2 votes
2 answers
2k views

Discover missing foreign keys and/or indexes

2 votes
1 answer
876 views

Join query with different column types in "on" part

1 vote
0 answers
4k views

Cannot drop constraint due to FK references

1 vote
0 answers
604 views

Inner join on array columns from 3 tables

1 vote
1 answer
40 views

Finding time ranges in multiple rows

1 vote
1 answer
69 views

Selecting a proper data warehouse and/or big data approach

1 vote
1 answer
8k views

Adding array element to JSON column in PostgreSQL [duplicate]

1 vote
1 answer
765 views

Too much data queued in replication slots

1 vote
1 answer
157 views

Optimizing column types for reduced overall database size

0 votes
0 answers
202 views

Upgrading PostgreSQL 9.4.9 to 9.6.x on Debian

0 votes
1 answer
44 views

New query taking over 60% of running time

0 votes
0 answers
28 views

Simple query rephrasing for optimization

0 votes
1 answer
151 views

Who deleted a record?

0 votes
1 answer
5k views

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

0 votes
1 answer
160 views

Missing / Orphan Indexes?

0 votes
3 answers
3k views

Metrics for monitoring master-slave replication

0 votes
0 answers
342 views

Comparing explain plains and execution time

0 votes
1 answer
130 views

Reclaiming unused indexes disk space

0 votes
1 answer
1k views

Join query with closest date in "ON" clause

0 votes
1 answer
206 views

Improve performance of query with many joins