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

Jul
1
comment Postgres table growing on massive updates
What is your Postgres version? What are your autovacuum settings? vacuum full is not such a good idea especially if you are using and older Postgres version.
Jul
1
comment PostgreSQL Automatic Failover (Trigger File Creation)?
postgresql.org/docs/current/static/app-pg-isready.html You might also want to have a look at repmgr which also supports automatic failover
Jul
1
comment Does mariadb provide a Type 2 driver?
Type 2 drivers are a relic from the old ages where no native (i.e Type 4) drivers were available. There is absolutely no reason to use one in 2014 - not even for "learning purposes". Btw: the DB doesn't care whether a JDBC driver is Type 2, Type 3 or Type 4. The driver always needs talks to the database in the same way. The difference is the code that runs on the client not how the communication is done.
Jul
1
comment How to grant drop table/function privileges to a role in PostgreSQL?
You might be interested in this: stackoverflow.com/questions/24410198/…
Jul
1
comment getting “table is full” error even if the table size is much smaller than tablespace
"a varchar(100) variable will reserve all the space like you have 100 characters in all rows of the column" - is that a special "feature" of NDBCLUSTER? Because InnoDB (or MyISAM) don't do that. It would be true for char(100) though.
Jul
1
comment How do I stop views (large data sets) from freezing my database
What exactly do you mean with "commands to refresh views"? A view doesn't need a "refresh" the data in there is always "up-to-date".
Jun
30
comment Is select * still a big no-no on SQL Server 2012?
I consider select * bad coding style in any DBMS not just SQL Server.
Jun
28
comment Restore an oracle dmp file
Are you sure the dump was taken using is a legacy tool exp. Could it be a dump taken using DataPump (expdp)? In that case you need to use impdp to import it. And imp doesn't "create folders" - so it's totally unclear what you are doing
Jun
28
comment What is the “other miscellaneous information” in the Shared Global Area (oracle database)?
A bit unrelated (because that part didn't change that much) but you shouldn't be studying the documentation of a totally outdated and unsupported Oracle version. Read the manual for 11.x at least (if not 12.x), not 9.x
Jun
27
comment Why is PostgreSQL doing a seq scan on column != column?
On second thought: the optimizer could recognize that the condition is always false. I don't know why it doesn't. Maybe you should post this to the Postgres mailing list.
Jun
27
comment Do I need foreign keys in ORMs?
Another reason: I have never seen a database with vital (enterprise) information that was only accessed by a single application. So it is unlikely that the application (and thus that specific ORM) will be the only thing that writes to the database.
Jun
27
comment Oracle Enterprise Manage “CPU utilization” is confusing
Thanks. Put like that, it does make sense ;)
Jun
26
comment PostgreSQL using count() to determine percentages (cast issues)
Of course you are right, the window function is not needed. But then it doesn't really make a difference (apart from readability).
Jun
25
comment Performance issue in Postgresql9.3
Unrelated but: work_mem = 30GB is way to high. The 30GB may be allocated multiple times per statement (for each sort/hash step during execution).
Jun
24
comment How list of netezza system tables/views?
If Netezza supports transactions, then there can't be such a view. If you have multiple transactions all deleting and inserting rows into a table at the same time, which row count should that view show you?
Jun
24
comment How to print ORDER wise using LEFT JOIN in SQL?
An order by in a derived table (or a sub-select) does not make any sense. You need to apply the order by to the complete query (not the derived table).
Jun
23
comment ORA-00907: missing right parenthesis on query with subqueries
Actually except is defined in the SQL standard. It's not specific to SQL Server. But apart from that, you are right. minus is Oracle's implementation of the standard except operator
Jun
23
comment Issue working with Postgres on Windows
Try the psql command on a real Windows commandline, not from within pgAdmin. Maybe pgAdmin doesn't pass the parameters correctly
Jun
23
comment Issue working with Postgres on Windows
But according to the manual -f should be equivalent to \i
Jun
23
comment How to improve query performance in PostgreSQL?
Ah, sorry. That was a typo. It should of course be work_mem