I have used postgres for so long that a lot of the baked in functions and features that were super convenient for me. I recall wanting to change a data type in

I have used postgres for so long that a lot of the baked in functions and features that were super convenient for me. I recall wanting to change a data type in my query and having to actually use the cast function. Also it was mentioned but when I was using it CTEs were not implemented yet. However, they weren't with postgres until 9.x as I recall either. Regarding performance, I mean, that is as much design as it is rdbms choice. Also i'm no DBA.