Reputation
14,246
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 26 54
Impact
~809k people reached

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/…
Mar
25
comment Connect to Oracle DB 9i using SSH TUNNEL via putty
You need to create an entry in tnsnames.ora that points to localhost
Mar
24
comment Return type of JOINing stored procedure - PostgreSQL
Why no use a view instead?
Mar
24
comment hierarchical query
Which DBMS are you using? Postgres? Oracle?
Mar
24
comment SQL SUM of different product groups in one query?
Although probably not relevant for such a basic question, you should always mention the DBMS you are using (Postgres, Oracle, DB2, ...)
Mar
24
comment PgAdmin III - Number of lines returned during insertion
Might very well be a problem in pgAdmin. Do you get the same numbers with other SQL clients?
Mar
23
comment What's the fastest way to migrate an Oracle database from Unix to Linux?
If Oracle is already running on the RedHat server, use expdp and impdp (or just impdp through a DBlink)
Mar
23
comment Oracle can't drop index with . in name?
docs.oracle.com/cd/E11882_01/server.112/e41084/…
Mar
21
comment Trouble renaming a PostgreSQL database
This is explained here and here