Reputation
647
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 18
Impact
~90k people reached

Jun
23
comment What happens if a client connection is killed while holding a lock?
@KennethFisher "I imagine it's like any other network connection": many protocols on top of TCP don't have heartbeats, they need to timeout (in the application) or to use TCP keepalive (which is generally a system-wide setting, not necessarily enabled).
Jun
13
comment Syntax error using preparedstatements with postgresql
You should be able to use string concatenation too, something like NOW() + (? || ' days')::interval.
Feb
25
awarded  Notable Question
Feb
20
awarded  Popular Question
Jan
28
comment How do I configure SQL Server 2012 so that it can restore and see files in my user account?
I'm not sure it clears the confusion... If you're logged on via WA, your SQL Server account needs the permissions to restore (as far as SQL Server is concerned), but the SQL Server service account needs the read permissions on the file system to open the .bak file (which it generally won't have if it's in your user directory, unless explicitly granted).
Nov
18
awarded  Notable Question
Nov
17
awarded  Yearling
Oct
15
awarded  Popular Question
Sep
30
awarded  Explainer
Jul
4
awarded  Popular Question
Jul
2
awarded  Curious
Jun
25
answered Return a default value in group by if selected column is null
Jun
25
asked Efficiently joining two irregular series representing changes
Feb
3
awarded  Informed
Jan
17
awarded  Popular Question
Nov
28
asked Limiting PostgreSQL logging
Jul
26
accepted PostgreSQL strategies to deal with disk filling up
Jul
26
comment PostgreSQL strategies to deal with disk filling up
Interesting, pg_freespace doesn't quite return as much as VACUUM FULL is able to reclaim aferwards, but I guess it's close enough. Thank you.
Jul
25
comment PostgreSQL strategies to deal with disk filling up
Sorry, I meant I'd like to know how much space belonging to the tables (and used on disk) is actually unused and re-usable. As far as I can tell, pg_database_size returns the size on disk.
Jul
25
awarded  Popular Question