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

13h
revised Finding all date ranges that overlap a target date range
edited tags
13h
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)
17h
revised pgAdmin export line overflow on large field
edited title
18h
comment Row with latest timestamp
wiki.postgresql.org/wiki/Slow_Query_Questions
18h
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.
18h
comment Remote connection to oracle database 12c
What happened when "they" tried?
18h
revised pgAdmin export line overflow on large field
edited tags
18h
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.
18h
answered How can i get list of postgresql database through php or using just sql query?
1d
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
Also: did you turn off autocommit?
1d
revised Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
added 63 characters in body
1d
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.
1d
revised Bidirectional Replication Push and Pull with SQL Server
edited tags
1d
revised I need to find the “rank” in a sub-set of entries
added 137 characters in body; edited tags
1d
awarded  Caucus
1d
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.
1d
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"
1d
revised How to restrict access to SQL Server user in some period of time
edited tags
1d
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)
1d
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