Question : I have a relatively simple query on a table with 1.5M rows: SELECT mtid FROM publication WHERE mtid […]
Tag: hibernate
Conditional Database View of Postgresql
Question : I have a situation here. Currently I have two polling tables (poll_one and poll_two) which will poll data […]
What kind of deadlock the deadlock_timeout config parameter detects in Postgresql?
Question : My overall goal is to get a 40P01/ERRCODE_T_R_DEADLOCK_DETECTED from postgres when an deadlock is detected. (To be more […]
Get TEXT value of a CLOB OID in Postgresql
Question : I have a database table that looks like: create table answers( id int not null, question_id int not […]
PostgreSQL query very slow when subquery added
Question : I have a relatively simple query on a table with 1.5M rows: SELECT mtid FROM publication WHERE mtid […]
Meaning of JOINs in sql
Question : I was trying to interpret the relationship between JOINs like LEFT-OUTER JOIN, RIGHT-OUTER JOIN, etc with relationships like […]
PostgreSQL query very slow when subquery added
Question : I have a relatively simple query on a table with 1.5M rows: SELECT mtid FROM publication WHERE mtid […]
How to handle many connections to a large MySQL database
Question : I have multiple java hibernate apps connecting to 1 single mysql DB. Sometimes some of the apps hangs […]
@OneToMany mapping but only one is needed
Question : I have to create a new table to store version numbers of Terms&Conditions user have accepted and the […]