16,821 reputation
44086
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 11 months
seen 18 mins ago

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.


Jan
24
comment how to check whether Oracle database is accessed or not?
Note that you need Diagnostic Pack to even access most of those views.
Jan
24
revised how to check whether Oracle database is accessed or not?
added 685 characters in body
Jan
24
comment Take advantage of monotonic columns in PostreSQL
you might be interested to know that ypercube suggested a simpler version of this answer in The Heap
Jan
24
comment Take advantage of monotonic columns in PostreSQL
I noticed that too late :)
Jan
24
revised Working of indexes in PostgreSQL
removed 'thanks' - votes and accepted answer are enough and this reduced noise for others
Jan
24
comment Take advantage of monotonic columns in PostreSQL
Also, you may like to read all the answers on this related question
Jan
24
comment Take advantage of monotonic columns in PostreSQL
hmmm, I should probably read the whole question before answering. Why would you want to avoid the workaround? The issue here is that you know your data better than postgres knows it (how could pg be sure the two columns are going to be monotonically related tomorrow even if it can see that they are today?)
Jan
24
revised Take advantage of monotonic columns in PostreSQL
added 321 characters in body
Jan
24
answered Take advantage of monotonic columns in PostreSQL
Jan
23
accepted Does postgres efficiently re-use space from deleted rows?
Jan
23
comment Is there are a way to restore System schema to it's original state?
Backups aren't for getting back to an empty database, use DBCA as you say or DROP/CREATE DATABASE.
Jan
23
comment Is there are a way to restore System schema to it's original state?
The question remains why those tables were imported in the system schema (or do you mean the system tablespace?). What were they doing in the system schema in the first place before the export?
Jan
22
comment Is there are a way to restore System schema to it's original state?
Do you mean you want to go back to an empty database? You can drop and create databases. What are these 'useless' tables (please give an example), I'm concerned they may not be as useless as you think.
Jan
22
comment Is there are a way to restore System schema to it's original state?
That's a 'full' import - what makes you think it has only affected the system schema? Note that objects owned by SYS and SYSTEM aren't exported in a full export. Do you have backups?
Jan
19
comment Monitoring Amazon RDS with pgtop
@dezso I'm not sure - I've edited to focus entirely on pgtop but it looks like the simple answer now is "no", so too localized.
Jan
19
revised Monitoring Amazon RDS with pgtop
deleted 98 characters in body
Jan
17
accepted Is there a way to insert multiple rows into a table with default values for all columns?
Jan
17
comment OLAP or OLATP - How to determine
Please do not assume you know who voted - just because someone commented does not mean they voted down. Votes are private for a reason and I've never seen any good come out of stressing about who voted which way and when.
Jan
17
asked Is there a way to insert multiple rows into a table with default values for all columns?
Jan
15
awarded  Nice Answer