What are the common bugs found while migrating to MySQL db to Postgre?
List out the disadvantages of PostgreSql Database.
Why the Update Statement works very slowly in Postgresql?
Why the updation and deletion is too slow in Greenplum as compared to Insertion?
Latest Answer: OID are used for unique row identification in POSTGRESQL. For identifying specific physical rows with block and offset values in POSTGRESQL TIDs are used. The relationship between OID and TID exists in such a way that whenever a row is altered the corresponding ...
Latest Answer: palloc is used to allocate memory in POSTGRESQL. POSTGRESQL memory allocation follows interesting concept of allocating memory within memory contexts. This concept helps in efficiency way of managing memory preventing many problems that pccurs due to ...
What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?
What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed?
Latest Answer: GEQO stands for Genetic Query Optimization. As the name implies this is used for query optimization in POSTGRESQL. The Genetic Query Optimization is used along with POSTGRESQL query evaluator and optimizer which helps in solving complex query paths and ...
View page [1] 2 3 Next >>
Go Top
