So I have a table with about 30 Billion Rows. I needed to insert 20 billion more. I have 2 indexes. One is a HUGE field (80 characters) and inserts are random. One is a simp...
Experts... What is your experience with the difference in DISK required for Oracle vs. PG? Right now we are showing 220% (more than double) space requirement of Oracle (edite...
A Valuable Lesson... WITH qry AS () ... Update tbl FROM qry... Was being rewritten by the optimizer. With HORRIBLE performance, hence the WITH Query. In The end, we were le...
Question: We have a set of data in 2 tables (tbl_A or tbl_B). One is always CURRENT and one is available to build new/fresher data. In the past, we would simply change the VI...
Try that. This will make it much easier to see what is wrong. Also, how is that server configured? Is it a Local VM, installed locally, installed under WSL, or AWS or other c...
Is there a way in plpgsql to choose from 2 cursors and only loop over one of them? Situation: 2 Queries, one is for salaried people, one is for Hourly. Both RETURN the same...
That's my point, how do you hard stop? Unless you loop over each row, and check each loop cycle...
Also, did you reboot windows after installing?
Yes, how do you program, when to stop?
Yes, whayou considering? considering?