15,361 reputation
33774
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 3 months
seen 10 hours 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.


Jun
27
comment How do you think in NoSQL?
@Vérace no, it is not a good fit for dba.se, it's far far too broad. We welcome specific answerable questions that don't solicit opinion and for which you couldn't imagine a whole book being written in answer. Usually that means specifying the exact platform (eg "MongoDB", not "NoSQL") as a minimum starting point. Note that I'm not saying the question isn't interesting just that it is not a good fit. If you want to answer this the right place would be on our blog not on main.
Jun
24
comment Move Oracle database to new server
By "without violating Oracle SE license" do you mean "only having one database mounted at a time"?
Jun
24
comment How to improve query performance in PostgreSQL?
@Craig please feel free to flag posts like this that are going nowhere and I'll close them. Read your blog post about CTEs and materialization the other day, thanks for that.
Jun
24
comment How to improve query performance in PostgreSQL?
This isn't working out here: as Craig has said, you need to go back to the drawing board and figure out what you are trying to achieve. I note that you still have rows=215655059 in your plan so perhaps you just have an unrealistic target.
Jun
17
awarded  Generalist
Jun
12
awarded  Popular Question
Jun
9
comment SQL Server 2012 - The application has failed to start because its side-biy-side configuration is incorrect
@mr5 tools like SSMS are on topic here. Can you post your comment as an answer?
Jun
7
revised Recovery from datafiles
edited tags; edited tags
Jun
6
comment Why can't I drop this Oracle datafile - even though it seems empty?
He should be able to drop just the datafile if it is empty. This looks a lot like bug 12735162 to me.
May
31
answered What is the difference between Interbase and Firebird?
May
31
comment How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
Thanks Erwin, it is now! Checking the link, it looks like it addresses the locking issues but like vacuum full/cluster does a full table re-write which my application can't afford, both for space reasons and because of the WAL generated.
May
31
comment What is the difference between Interbase and Firebird?
@Colin that link is dead for me, can you still see it?
May
30
comment How to make continues cluster?
I'm not sure I understand something here, if your query is looking at all values of providerid, why are you clustering on providerid, date rather than just date. also is data a typo for date? And is x different in data < x and date > x? Anyway, you may be interested in this question/answer.
May
30
asked How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
May
30
answered How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
May
30
comment Does postgres efficiently re-use space from deleted rows?
Yes, vacuum full writes a new table so no 'junk' data (un-zeroed free space) will survive.
May
30
revised How do data checksums interact with streaming replication?
added 202 characters in body
May
29
comment How do I decompose ctid into page and row numbers?
Also perhaps worthy of note is that pg_freespacemap uses bigint for blkno
May
29
asked Does postgres efficiently re-use space from deleted rows?
May
29
answered Does postgres efficiently re-use space from deleted rows?