Infrastructure at your Service

Category Archives: Postgres

Franck Pachot

Postgres vs. Oracle access paths – intro

By | Oracle, Postgres | 2 Comments

This is the start of a series on PostgreSQL execution plans, access path, join methods, hints and execution statistics. The approach will compare Postgres and Oracle. It is not a comparison to see which one is better, but rather to see what is similar and where the approaches diverge. I have a long experience of reading Oracle execution plans and no experience at all on Postgres. This is my way to learn and share what…

 
Read More
Franck Pachot

PostgreSQL on Cygwin

By | Postgres | 5 Comments

I run my laptop with Windows 10 for office programs, and VirtualBox machines with Linux for the big stuff (Oracle databases). I have also Cygwin installed on Windows for GNU programs. I wanted to quickly install PosgreSQL and rather than installing it in a Linux VM, or as a Windows program, I installed the Cygwin version of it. Here is how.  

 
Read More