Reputation
15,334
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 58
Newest
 Caucus
Impact
~981k people reached

3m
comment How Do you add multilanguage support in oracle 12c post installation?
So you are not looking for multi language support but for a different character set support. The character set cannot be changed once the database have been created. Bu you should be able to store those characters in a NVARCHAR2 column (N = National Character Set). That defaults to a multi-byte character set. If you really, really need to store that in a VARCHAR2 column. You will need to dump the existing data, re-create the database and the import the data again.
1d
comment How Do you add multilanguage support in oracle 12c post installation?
What exactly do you want to achieve? Get error messages in a non-english language?
1d
comment Selecting the correct database engine
@miracle173: of course Postgres is an RDBMD (actually an ORDBMS)
1d
comment Best Admin Tool for Postgres
You forgot to mention that Postgres Enterprise Manager is a commercial product and is not an open source tool (which is what Jeevitha is looking for)
1d
comment insert value based on check constraint on another column
There is no mentioning of an array in your question (and an array is still storing multiple values in a single column). You need to add some sample data and a description on how the system should behave with the sample data. As it stands I for one have no idea what you are trying to achieve.
1d
comment Selecting the correct database engine
Postgres fits your list. It has an extremely efficient key/value store, supports JSON (even indexing JSON documents) and has very good SQL support (far better than the mentioned MySQL)
1d
comment Best Admin Tool for Postgres
psql comes to mind. An extensive list is here: wiki.postgresql.org/wiki/…
1d
comment insert value based on check constraint on another column
Do not store multiple (comma) delimited values in a single column. Normalize your model instead
2d
comment Finding all date ranges that overlap a target date range
If you are limited to Oracle and SQL Server you should not have stated that the "choice of RDBMS is not fixed". Btw: Postgres does qualify as a "standard DBMS". Postgres range types are extremely efficient and powerful. Neither Oracle nor SQL Server has anything like that (including unique constraints on them)
2d
comment Row with latest timestamp
wiki.postgresql.org/wiki/Slow_Query_Questions
2d
comment Remote connection to oracle database 12c
Sorry I can't see your computers from over here and my crystal ball is broken so I can't see what you did, nor how you configured your Oracle instance, nor how you configured your notebook, nor how your teammates connect to your laptop, nor how your network is setup.
2d
comment Remote connection to oracle database 12c
What happened when "they" tried?
2d
comment pgAdmin export line overflow on large field
The truncation of the value is not done by Postgres, but by pgAdmin (the client application). Other SQL clients might be better at this. I don't use pgAdmin, but I recall other questions regarding this, and I think there is an option somewhere that limits the amount of data displayed to the user. pg_dump can create a valid plain SQL dump for this.
2d
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
Also: did you turn off autocommit?
2d
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
You might also want to try out Postgres 9.4 - there were several changes that might give you better insert performance. wal_buffers = 32MB seems also on the high side. Is there any reason you changed that away from the auto-tuning value of -1. work_mem = 2GB seems too high as well (although irrelevant for inserts). Remember that work_mem can be request several times by each statement that is running. I have also seen discussions where reducing shared_buffers lead to a better write performance.
2d
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
I also don't think the memory usage is any indicator of a good or bad resource consumption. As matter of fact I'm surprised that the Oracle processes (Oracle doesn't use threads on non-windows systems) use that much memory for plain inserts. Why would an insert need that much memory, there is no sorting or similar things going on. One thing you could try is to use batched multi-row inserts (insert into .. values (..), (...), (...)) in Postgres.
2d
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
"AND I DO NOT want to use COPY statement" translates (for me) to: "I want it to be faster but I don't want to use the method that is guaranteed to be faster"
2d
comment Is it reasonable to mark all columns but one as primary key?
Btw: adding the title to the PK or a unique constraint won't really help that much. Because you won't catch duplicates that differ in case or spelling e.g. The Fifth Element and The fifth element will be considered different titles (or think of numbers in sequels, Part 2 vs. Part II) Same goes for the genre: SF vs ScienceFiction vs. Science Fiction (for genre I would probably create a lookup table and reference that from the movies table)
2d
comment Is it reasonable to mark all columns but one as primary key?
From my point of view: yes. Because you can easily create FK constraints pointing to that table. And you can change the conditions for uniqueness without affecting the PK
2d
comment Is it reasonable to mark all columns but one as primary key?
I'd go for the second solution (add additional unique indexes to enforce uniqueness).