Skip to main content
András Váczi's user avatar
András Váczi's user avatar
András Váczi's user avatar
András Váczi
  • Member for 12 years, 10 months
  • Last seen more than a month ago
  • Hungary
44 votes
5 answers
35k views

Unit testing of stored procedures

19 votes
2 answers
19k views

Index on primary key not used in simple join

15 votes
6 answers
22k views

How to conditionally stop a psql script (based on a variable value)?

11 votes
2 answers
4k views

Getting SQLSTATE in psql error messages

10 votes
2 answers
773 views

Huge mismatch between reported index size and number of buffers in execution plan

10 votes
2 answers
1k views

How exactly the row visibility is determined?

8 votes
2 answers
15k views

How to get user-specific settings in PostgreSQL?

6 votes
1 answer
1k views

Stored procedure deadlocking itself

5 votes
1 answer
1k views

User can drop table from a schema, but cannot create one

5 votes
2 answers
308 views

Performance of different precedence pseudocolumn solutions with LIMIT

3 votes
1 answer
263 views

psql coloured prompt misbehaving

3 votes
0 answers
552 views

Stubborn autovacuum process slow things dows

1 vote
1 answer
1k views

slow index scan on postgresql 9.1