Nope, in Oracle you can run this query on any table to view the data it held yesterday:
select * from emp as of timestamp(sysdate-1);
>Oracle uses a statistical optimizer for execution plans in the engine. >They are working through the 2nd generation of it to handle situations where they are lots of high frequency values Here you go. Perhaps Oracle's statistics are more sophisticated: can you enlighten us?
At a first glance postgres seems to have all the important stuff in there, but I'm not sure how postgres handles the execution plans for prepared statements when you have skewed data and histograms on a column. This was a pain in oracle 10g and lower....
> Temporary table undos Don't know about this one.
Temporary tables in oracle are tables with data only available for the duration of your session. Everyone use the same table, but they only see their own data. Because there's no ACID compliance here there's very little redo/undo generation (WAL and undo)