jobinau

4 ms·

1.
by jobinau 4y ago
Oracle is 25 million lines of code vs 1.3 million lines of code of PostgreSQL Still Oracle don't have all basic isolation levels. Only the Read-Commited works perfect. And DDL operations are still not transactional. We should think whi
2.
by jobinau 4y ago
Every software has imperfections. thats why new versions comes with improvements. There is no end to it
3.
by jobinau 5y ago
Yes, that is a very common case. The highest reported problem with aurora is the unexpected spikes in CPU utilization. While Same load on regular (the real) PostgreSQL is not causing any spike.
4.
by jobinau 5y ago
Agree. It is impossible to create a replacement for worldwide community project like PostgreSQL. It is the knowledge of humanity. Just like English literature or Any Branch of Science. We can add to it. But we cannot replace it completely.
5.
by jobinau 6y ago
One of the problem with temporary tables is that it will result in adding metadata information into PostgreSQL catalog (pg_class), and it will easily get bloated as the temporary table ends its life
6.
by jobinau 6y ago
I think the selection Tcl is a right choice than Perl. considering the Lightweight nature of Tcl
7.
by jobinau 8y ago
Yes, It helps a lot in Oracle to PostgreSQL migration
8.
by jobinau 8y ago
Suppose we want to run a complex reporting query on tables in Sales database (running MySQL) and Finance database (running PostgreSQL). What is the good option without duplicating data from one system to another?
9.
by jobinau 8y ago
PostgreSQL and MySQL are the most popular database systems. Yes, they can talk and share data using mysql_fdw
10.
by jobinau 8y ago
A summary of all the main features included in the PostgreSQL FDW so far with Illustration.
11.
by jobinau 8y ago
Understanding every turning knob available in PostgreSQL is important to get maximum out of PostgreSQL server.