Reputation
12,552
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 59
Newest
 sql
Impact
~670k people reached

Mar
16
comment PostgreSQL Bloat Warning: Vaccuum does not help
Is it causing anything bad? If you have a working autovacuum setup, the table should not grow much.
Mar
15
revised Postgres Data Dump problem
deleted 10 characters in body
Mar
15
comment Declare variable for SELECT statement in Postgres function
@liquid in my experience, moving from 8.4 to anything (up until 9.4, IIRC) is quite seamless.
Mar
15
answered Declare variable for SELECT statement in Postgres function
Mar
14
revised Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
added 28 characters in body
Mar
14
revised Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
added 40 characters in body
Mar
13
reviewed Close Why Does Oracle kill a session at the specific time?
Mar
13
revised Can't drop UNDO TABLESPACE
added 105 characters in body
Mar
11
comment N-dimensional vectors in PostgreSQL Spatial Index
No, this was clear. But an index makes sense only if it helps you run your queries faster. BTW, which version are you on?
Mar
11
reviewed Reopen What is the role of eager writer?
Mar
11
comment N-dimensional vectors in PostgreSQL Spatial Index
'Whether the 'path' type ... will be suitable for my purposes' - but you did not describe those pruposes :)
Mar
11
revised Detect when a CREATE INDEX CONCURRENTLY is finished in PostgreSQL
edited body
Mar
11
answered Postgresql: how to remove a GRANT on multiple tables?
Mar
11
comment Postgresql: how to remove a GRANT on multiple tables?
postgresql.org/docs/current/static/role-removal.html 'and any permissions granted to the role must be revoked'
Mar
10
revised How to trunc double precision number without rounding?
added 4 characters in body
Mar
10
revised How to trunc double precision number without rounding?
added 40 characters in body
Mar
10
revised How to select number of affected rows to variable in function?
added 38 characters in body
Mar
10
comment Where to look for possible deadlock causes?
Any triggers on any of those tables?
Mar
10
reviewed Close Encapsulate table with view
Mar
10
reviewed Close rubric for students mysql 5.7