Re: [GENERAL] some questions about pg

> 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