Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 1 11
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 19 votes cast
May
7
awarded  Popular Question
Apr
30
awarded  Teacher
Apr
23
awarded  Commentator
Apr
23
comment How do I sort the results of a recursive query in an expanded tree-like fashion?
Can someone explain me there does the depth column comes from? I do not see it in the initial table structure.
Feb
9
awarded  Critic
Feb
9
comment Why won't PostgreSQL 9.3 start on Ubuntu?
This may be an workaround but clearly not a good solution. This one like is fixing the problem dba.stackexchange.com/a/91511/8099
Feb
9
answered Why won't PostgreSQL 9.3 start on Ubuntu?
Dec
30
awarded  Famous Question
Jun
30
awarded  Popular Question
May
11
accepted Does it make sense to upgrade to a newer PostgreSQL JDBC driver?
May
10
comment Does it make sense to upgrade to a newer PostgreSQL JDBC driver?
you do not mention anything about performance or stability. i am not interested about features, as clearly the application is not going to use them as it was not designed to benefit from them. also i have serious doubts that the app will need access to metadata.
May
5
asked Does it make sense to upgrade to a newer PostgreSQL JDBC driver?
Mar
4
comment Is it possible to quickly create/restore database snapshots with PostgreSQL?
Update: this will not work in production because the source database will have connections to it. We need another solution.
Feb
12
comment tuning postgresql for large amounts of ram
Last update of pgtune was in 2009, that's 5 years ago and still counting. I am wondering if its still valid for 9.1-9.2-9.3 series.
Feb
11
comment How to properly monitor the number of PostgreSQL database connections?
@CraigRinger maybe I could configure Postgres or the clients to keep connections open for a longer period of time, so I could measure them. Due to the current setup I had one case when the postgres started to refuse connections. Monitoring was not able to detect this because this happened inside the 5 minute interval, and it went from below warning level to above critical in less then 5 minutes. And this was not a DoS attack.
Feb
11
asked How to properly monitor the number of PostgreSQL database connections?
Nov
11
accepted How to drop all connections to a specific database in postgres without stopping the server?
Nov
10
awarded  Notable Question
Oct
8
comment Is it possible to quickly create/restore database snapshots with PostgreSQL?
This is a great solution, 5x faster than drop-restore but is has one downside: you need to drop current connections before doing this otherwise it will fail to run.
Jul
24
awarded  Supporter