The EDB Blog

As the name suggests, a nested subprocedure allows us to write a function or procedure nested within another function or procedure. It means a function can have another function within it, just like its own variable. And, as this inner function is part of the outer function, it has no visibility outside the function that encloses it.

Quest Software recently released Toad Edge 2.0, which adds support for PostgreSQL and EDB Postgres. This reduces the time that DBAs and developers need to spend managing their Postgres databases, while ensuring optimal performance. This post was recently shared in the Toad Edge Community, which...

I admit it: I invented force_parallel_mode. I believed then, and still believe now, that it is valuable for testing purposes. Certainly, testing using force_parallel_mode=on or force_parallel_mode=regress has uncovered many bugs in PostgreSQL's parallel query support that would otherwise have been...

With so many workloads being migrated to the cloud, this is a question we get all the time. For anyone making this move there are many choices to make and options to consider. In this post, I will step through those to help you decide on a path forward. First, recognize that not every workload is...

EDB recently had the pleasure of inviting Noel Yuhanna to present at a webinar we hosted— Databases in the Cloud: Today's Realities and Tomorrow's Promise . Yuhanna is a principal analyst at Forrester, serving enterprise architecture professionals. This webinar was well attended, and that was no...

Cost based optimization A query may be executed in many different ways, modeled as plans in the query optimizer, differing in resources required and/or execution time. A typical DBMS's query optimizer tries to find all of the possible plans for executing a given query and chooses the fastest plan...

PostgreSQL 10 introduced declarative partitioning, which included list and range partitioning. But, it had always been an open question as to what happens if we get rows which do not qualify to be placed in any of the given list/range partitions. That's when PostgreSQL 11 introduces a solution to...