From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres as In-Memory Database? |
Date: | 2013-11-20 00:29:01 |
Message-ID: | CAMkU=1wvpq8uy7oxQZFajtcJ5pF_TKkP_3M6DmS1Zwd3CkeM0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter <edsonrichter(at)hotmail(dot)com>wrote:
> Yes, those optimizations I was talking about: having database server store
> transaction log in high speed solid state disks and consider it done while
> background thread will update data in slower disks...
>
> There is no reason to wait for fsync in slow disks to guarantee
> consistency... If database server crashes, then it just need to "redo" log
> transactions from fast disk into slower data storage and database server is
> ready to go (I think this is Sybase/MS SQL strategy for years).
>
Using a nonvolatile write cache for pg_xlog is certainly possible and often
done with PostgreSQL. It is not important that the nonvolatile write cache
is fronting for SSD, fronting for HDD is fine as the write cache turns the
xlog into pure sequential writes and HDD should not have a problem keeping
up.
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2013-11-20 00:56:48 | Re: Postgres as In-Memory Database? |
Previous Message | David Johnston | 2013-11-19 22:19:58 | Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml |