16,811 reputation
44086
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 11 months
seen yesterday

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.


Mar
13
awarded  Revival
Mar
11
revised How do I get the difference in minutes from 2 timestamp columns?
removed aside that could be taken as snark
Mar
5
comment Order by alphabet and then by numbers
Is substring(text,text) an undocumented variant of substring(string from pattern)?
Mar
2
revised mysqlcheck --repair a specific table?
added 344 characters in body
Mar
2
awarded  Notable Question
Feb
3
awarded  Famous Question
Jan
29
comment Export Postgres table as json
What version of postgres are you running?
Jan
29
revised Export Postgres table as json
clarified from comment
Jan
27
revised Postgres 9.0 recovery from inadvertent drop-all-tables event
edited tags
Jan
26
reviewed Leave Open What is WITH QUERY EXPANSION MODE in MySQL Fulltext Search
Jan
26
reviewed Leave Open Restoring an Oracle Backup Properly
Jan
26
reviewed Leave Open Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
Jan
26
reviewed Leave Open Tools to migrate from SQLite to PostgreSQL
Jan
26
revised What's the difference between a CTE and a Temp Table?
This needs to be an answer, not a direct response to another answer (which would need to be a comment on his answer). I've adjusted accoringly.
Jan
25
revised Is inserting multiple queries takes same time as that of single query?
edited tags; edited tags
Jan
25
comment Take advantage of monotonic columns in PostreSQL
@giomasce it doesn't necessarily mean that - a functional index could cast/round. eg if your fp values are between 0 and 1, and your integers between 0 and 1000, multiply by 1000 and round for the index. Obviously your query will have to do the same conversion as the index for it to be used.
Jan
25
comment Take advantage of monotonic columns in PostreSQL
@a_horse_with_no_name thanks. Those 3 blocks touched are all the rows with foo<=1100. If that foo condition doesn't restrict the matched rows much then most of the index is scanned even when the query ultimately returns the same number of rows (113).
Jan
25
comment Take advantage of monotonic columns in PostreSQL
@a_horse_with_no_name does the plan show what percentage of the index is touched, or if not is there any way of getting that statistic?
Jan
24
comment how to check whether Oracle database is accessed or not?
What version of Oracle do you have?
Jan
24
revised how to check whether Oracle database is accessed or not?
removed tagline