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

Database "frozen" on ALTER TABLE

13 votes
1 answer
38k 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
973 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
229 views

PostgreSQL database re-design considerations

2 votes
2 answers
2k views

Discover missing foreign keys and/or indexes

2 votes
1 answer
849 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
598 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
752 views

Too much data queued in replication slots

1 vote
1 answer
151 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
132 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
156 views

Missing / Orphan Indexes?

0 votes
3 answers
3k views

Metrics for monitoring master-slave replication

0 votes
0 answers
340 views

Comparing explain plains and execution time

0 votes
1 answer
120 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