> May be PostgreSQL is better in SQL conformance
It sticks very close to the standard and any non-standard things are very well documented. It does have common table expressions as well as windowing functions.
> i'm told its performance is not the best.
That is simply not true. Version prior to the 8.x line were indeed slower than e.g. MySQL (which simply sacrifices reliability for speed).