Reputation
8,292
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~404k people reached

Jun
25
comment Database structure for hierarchical quiz?
Please explain it a bit and show the relations between the tables.
Jun
25
comment DBMS_REDEFINITION don't copy data?
I have the feeling that the solution is to extend the undo tablespace to some senseful size. Also, how important are those Middleware logs?
Jun
25
comment I am installing postgres-xl. While initializing the coordinator, i am getting the error below
We don't see you filesystem, so you may want to add some details about where the installation is located and so on.
Jun
25
comment How to organise huge mysql database for emails and search through it
Some clarification would be very welcome - what do the words 'tons' and 'crazy' mean in this context? Also, what is a 'foreign key structured database'?
Jun
24
comment Why does connecting to '127.0.0.1' work whilst 'localhost' fails?
... at least the only line related to the issue. It's not uncommon to have a bunch of entries there, like in my case, for some VMs and other stuff.
Jun
24
comment PostgreSQL: pgbouncer cannot connect to server
Do you see something in the DB logs?
Jun
24
comment DBMS_REDEFINITION don't copy data?
How big is your undo tablespace?
Jun
24
comment Mysql binlog warnings
Are you familiar with this: dev.mysql.com/doc/refman/5.7/en/… ?
Jun
24
comment Building a ColumnStore index hogs system resources
You should possibly add some findings (form logs, monitoring, etc.) that support that the columnstore build is the culprit.
Jun
24
comment Is it ever ok to not test a feature?
You did not define exactly what you mean by testing. It can mean very different things.
Jun
24
comment Exchange Partition
I think it really tells what you have to do: create the same index on tableTemp, too.
Jun
24
comment Multiple left join where not in another table
You have an inner join where a (supposedly) primary key column (user.id) is null - this does not help in getting any results :)
Jun
24
comment Multiple left join where not in another table
As this is a database question, it would be more handy to have the data in the form of an INSERT statement...
Jun
24
comment Exchange Partition
What is the exact error message?
Jun
24
comment Is there an equivalent in postgresql to MySQL's “safe update mode” or “safe delete mode”?
And one more question: the MySQL names suggest that this (whatever it is) is safe. Safe from what? In other words: what's your intended use of this?
Jun
24
comment How can I install Oracle (10g or above) on my MacBook running OS X Yosemite (10.10.4)?
docs.oracle.com/html/B13954_01/toc.htm
Jun
24
comment DBMS_REDEFINITION don't copy data?
2M rows usually do not require partitioning - these days it's not even considered as a big amount of data (unless the table is very wide). You possibly want to change the relevant settings :) On the other hand, it is also possible to remove the rows in small batches.
Jun
24
comment DBMS_REDEFINITION don't copy data?
From the documentation it looks like this is not in the scope - the aim is to change how the table is stored or its structure. Why cannot you simply delete the unnecessary data before redefining the table?
Jun
24
comment SQL Server : trigger FOR DELETE
And don't forget to add some explanation. Without it, your post was automatically flagged as low quality.
Jun
24
comment stored procedure vs. function in postgresql and which is better for executing dml statements
@CraigRinger OK, I was not aware that you can handle transactions in an Oracle SP - in the end it makes sense considering nested transactions.