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

6h
revised Auditing Table in Oracle Using SQL
edited tags
14h
revised Some records are missing while selecting from table
added 58 characters in body
1d
comment Postgres is using 100% CPU
Check pg_stat_activity while you have the high load to see which statement causes this. Then post the details for that statement (see: wiki.postgresql.org/wiki/Slow_Query_Questions)
1d
comment How to emulate transactions if you don't have access to them?
Sorry I don't get how the ability to issue those statements relates to the thread safety of the client being used - and which client is that anyway?
1d
comment How to emulate transactions if you don't have access to them?
What do you mean with "does not support commit or rollback"? If you can enter and send SQL statements you can enter and send commit and rollback, can't you? It also depends whether that "database client" supports disabling an "autocommit" mode.
1d
answered Grant privilege to see column names in null constraint violations when inserting in views
1d
comment Selecting where nullable boolean is not true
where bool is distinct from true would be ANSI SQL
2d
comment Oracle: convert upper on the fly
select upper('ibm') from dual?
2d
comment Is there a way to store a PostgreSQL database directly on a block device (not filesystem)?
Btw: Oracle no longer supports raw devices starting with version 12c: docs.oracle.com/database/121/READM/chapter12102.htm#READM123
2d
revised SELECT DISTINCT on multiple columns
edited tags
2d
comment Filter several columns and order it from a table
Don't add sample data as screenshots. Posts formatted text including the definition of the tables involved. Ideally everything as a small SQL script. Or even better: create a little sqlfiddle.com And tell us which DBMS you are using. Postgres? Oracle?
May
27
reviewed Approve Troubleshooting high disk read - buffer cache query
May
27
comment Troubleshooting high disk read - buffer cache query
Which DBMS are you using? Postgres? Oracle?
May
27
reviewed Approve Troubleshooting high disk read - buffer cache query
May
27
comment GROUP BY very slow when returning many rows
wiki.postgresql.org/wiki/Slow_Query_Questions
May
27
revised How can I delete all users except 1
edited tags
May
27
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
May
26
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.
May
25
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.
May
25
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