Reputation
18,774
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
4 34 65
Newest
 Nice Answer
Impact
~1.3m people reached

Apr
2
comment Slow query over 10mil rows with group by on indexed column
The majority of the time is spent in reading the values (31 seconds for the Seq Scan), the hash aggregates only adds 8 seconds on top of that. You might want to try an index on begindatumtijdvakgeldigheid if the condition for that column reduces the number of rows substantially.
Apr
2
comment Oracle: Traversing a graph of my foreign keys?
@ypercube: I didn't test it, but I would assume the query will fail unless you use CONNECT BY NOCYCLE
Apr
1
comment Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?
I guess Oracle thought the space saving is more important than the speed (if there is one at all). In other database you need to choose a different data type if you want to save space when storing e.g. values from 1 to 100. I think variable length numbers make absolute sense. Think about the space a table with 20 number columns needs when you to store 1 billion rows between 1 and 1000 and 1000 rows with a value 999999999999
Apr
1
comment Oracle Database Migration using Oracle SQL Developer
expdp and impdp are probably a lot more efficient than using SQL Developer for this. If you can create a DBLink you don't even need intermediate files for that
Apr
1
comment pg_restore a view
As a workaround: why don't you use select pg_get_viewdef('viewname') to extract the source of the view? I don't think pg_dump does it any different.
Apr
1
comment Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
I guess a better place to ask this is the Postgres performance mailing list.
Mar
30
comment Oracle: built in SQL pretty-print?
There is no such feature inside the database. Oracle's SQL client "SQL Developer" can do that though
Mar
30
comment SQL update multiple columns matching a pattern
I wrote "MySQL ignores inline foreign key constraints" which is still true with 5.6: sqlfiddle.com/#!9/fc801/1
Mar
30
comment SQL update multiple columns matching a pattern
You don't need to run multiple updates, you can update more than one column in a single update.
Mar
30
comment Have: Postgres database files. Need: Functioning database
I don't know Ubuntu, but with a "vanilla" Postgres all you need to do is point pg_ctl to the right data directory, e.g. pg_ctl -D /path/to/database/file start.
Mar
29
comment Query that was working on MySQL is not working on PostgreSQL
Don't compare numbers and strings. Use proper numeric literals 37 is a number, '37' is a string.
Mar
29
comment Query that was working on MySQL is not working on PostgreSQL
I also don't understand "Postgres - works" vs. "doesn't work on PostgreSQL" what exactly is "working" and what exactly is "not working"
Mar
29
comment VACUUM FULL fails with 'ERROR: Check free disk space'
You probably need to vacuum each table individually and see which one generates the error. A vacuum full essentially re-writes the complete table by copying it. Why do you think you need vacuum full at all?
Mar
28
comment How can I drop and create postgresql views in dependency order?
Put each view into a single SQL script, create one script to drop all views and another one calling each "view script" to re-create the views
Mar
27
comment Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Strange. The MacMini does the sort (in B2) much faster than the t420 even though it does it on disk and the t420 does it in memory. That sounds awfully strange.
Mar
27
comment Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Can you show us the execution plans (explain (analyze, verbose, buffers) select ... ) from both servers for one of the slow queries?
Mar
27
comment PostgreSQL pg_upgrade --link mode performance issue after upgrade
Sounds as if the statistics aren't up-to-date. pg_upgrade creates a script for that. Did you run it?
Mar
27
comment SQL Server to Oracle migration
And what is your question?
Mar
26
comment Linking SQL Server tables to a PostgreSQL Server
wiki.postgresql.org/wiki/FDW
Mar
26
comment Why is MySQL not saving inserted data?
See here: stackoverflow.com/questions/7655824/… or here: stackoverflow.com/questions/10742133/… or here: stackoverflow.com/questions/9318347/…