Reputation
14,635
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 28 54
Newest
 Yearling
Impact
~864k people reached

6h
comment Troubleshooting high disk read - buffer cache query
Which DBMS are you using? Postgres? Oracle?
6h
comment GROUP BY very slow when returning many rows
wiki.postgresql.org/wiki/Slow_Query_Questions
16h
comment A question about oracle upgrade from 12.0.0.1 to 12.0.0.2 using dbua
There is neither a version named 12.0.0.1 nor 12.0.0.2
1d
comment Why have both a postmaster and postgres executable?
There is another thing to consider: (at least) on Windows pg_ctl will drop elevated privileges and thus allows to start Postgres through an administrative account. Running postgres.exe directly will fail. I don't know if that is the same on Linux (postgres refusing to run as root) or if this behavior (dropping elevated privileges) could have been built directly into the postgres binary as well.
2d
comment Ongoing Administration comparison PostgreSQL vs Firebird
Postgres is known to be extremely robust and the Postgres development team puts "data safetey" (and correctness) over everything else. But Firebird is also know to be very reliable. But given the development momentum of Postgres and Fireibird I could hardly find a reason that would convince me to choose Firebird over Postgres. There is one feature that Postgres does not offer: running in embedded mode (e.g. in-process with your application, not as a server). So if that is something you require, the decision is easy.
2d
comment Ongoing Administration comparison PostgreSQL vs Firebird
From my perspective this should not be a deciding factor. You should decide on the features that each DBMS offers. You should also take into account that the Firebird project has been working on the next major version (3.0) for nearly 4 years now and are postponing the release again and again. Postgres also offers a lot more features than Firebird and the documentation is also much better. But in general I do think Postgres requires a bit more administrative attention than Firebird
2d
comment best software to run Oracle code
The best software to practice Oracle? I'd say: Oracle
May
24
comment How is encoding done in SQL database tables for pattern matching?
much faster is debatable and depends a lot on the DBMS being used: depesz.com/2012/06/07/123-vs-depesz-what-is-faster
May
22
comment Dividing values from a single column into 2 based on a rule
Which DBMS are you using? Postgres? Oracle?
May
21
comment Left Outer Join doesn't give expected result. What am I missing?
b.fld will be null if the outer join does not find a corresponding row.
May
21
comment Postgres Query Optimisation (Rails App)
For a statement processing all rows of a table, there is not much you can do - indexes will never help for that. If you are on 9.4 already you might try to use the new filter() expression instead of the case - sometimes that improves the performance (but then not much I would assume)
May
20
comment how to migrate data between two distincts tables
If the new table is in a different database: export the data using a COPY and an appropriate SELECT statement. Then import the data in the target database e.g. using COPY again. If the new table is in fact in the same (physical) database, you can do an insert into new_table ... select ... from old_table (provided you can do the "transformation" in pure SQL)
May
18
comment Does MariaDB support schema changes inside a transaction?
from the manual: "DDL statements (CREATE, ALTER, DROP) [...] cause an implicit COMMIT"
May
18
comment install GUI for Oracle Linux 7.1 after I installed with default settings with no gui
I'm voting to close this question as off-topic because this belongs on superuser
May
18
comment How to set correctly utf8 on oracle?
That's your SQL client (presumably SQL*Plus) which cannot display those characters. You need to use a font that can display them and in case of SQL*Plus you also need to switch the command line from which you start SQL*Plus to UTF-8 (I think that is done through chcp 65001)
May
17
comment Postgres: Subquery in select similarity
What is your question? What problem do you have?
May
17
comment How to connect a website to database
PhpmyAdmin is not a database. It's a PHP front end for the DBMS named MySQL
May
17
comment What are the compression options for storing large amounts of text in Postgres?
from the manual: "Long strings are compressed by the system automatically" and here is a more detailed description: postgresql.org/docs/current/static/storage-toast.html
May
16
comment Oracle database for learning purposes
There is no Oracle Express edition for OS-X (actually I think there is no Oracle version for OS-X at all). However you can download a VirtualBox image that contains a pre installed environment: oracle.com/technetwork/community/developer-vm/index.html#dbapp (that is however Oracle 12 - if you really need Oracle 11, then you need to download the version for Linux and install that manually in a VirtualBox environment: oracle.com/technetwork/database/database-technologies/…
May
16
comment Oracle Equivalent of the following SQL Server syntax
What does it do?