| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | randyboy <randyboy(at)whispers(dot)blackmist(dot)org> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] some questions about pg |
| Date: | 1999-10-04 04:06:16 |
| Message-ID: | 199910040406.AAA09177@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Diaz | 1999-10-04 04:15:39 | subscribe |
| Previous Message | Bruce Momjian | 1999-10-04 04:04:59 | Re: [GENERAL] PostgreSQL vs Mysql comparison |