> 3) I was under the impression that RDBMS transactions all include a write
> to a log file in addition to the db insert/update/etc which allows you to
> rebuild the db should anything happen. If that were the case, then what
> purpose does fsync mode serve?
It will be in 6.6, due out in a few months.
>
> 4) I've read in a lot of places that the postgres' speed can be reduced,
> even dramatically reduce, by using query optimization, stored procedures
> and what not. What is the learning curve associated with that?
No learning curve. See FAQ item on performance.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026