Re: Why is writing JSONB faster than just JSON?

> On Fri, Apr 23, 2021 at 01:56:57AM -0700, Mitar wrote: > Hi! > > On Thu, Apr 15, 2021 at 12:11 PM Dmitry Dolgov <9erthali...@gmail.com> wrote: > > > My point was that for JSON, after validating that the input is > > > syntactically correct, we just store it as-received. So in particular > > > t

PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?

Hi all, On 2019/10/09, I posted a question here concerning PostgreSQL I/O, the (primarily) Linux fsync problem and my lecturer's attitude to PostgreSQL (text of that email is at the bottom of this post). I asked why the fsync issue didn't affect Oracle and/or MySQL for example? As far as I can

Is this the future of I/O for the RDBMS?

Hi all, Kind of a followup to my question: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?, I have another. The blog below kinda got me thinking about all of this. I have an interest in NewSQL distributed systems - in particular CockroachDB, TiDB an

Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?

This wiki page. It has PR references for mysql and mongo for the fsycnc issue. Fsync Errors - PostgreSQL wiki I'd leave the more intellectual brainstorming to the experts. Also, ask for concrete references / reproducible scenarios for opinions if y

Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?

On 5/2/21 8:46 AM, Pól Ua Laoínecháin wrote: [snip] Now, I'm not quite sure that I completely comprehend matters: Is there a difference between Asynchronous I/O and Buffered I/O? * Asynchronous (a-syn-chron-ous) is an adjective which means "not together with time". * Buffered means "read more

Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?

On 2021-05-02 14:46:41 +0100, Pól Ua Laoínecháin wrote: > Now, I'm not quite sure that I completely comprehend matters: Is there > a difference between Asynchronous I/O and Buffered I/O? Yes. Buffered I/O means that there is a buffer (or maybe several layers of buffers) between the application an

Re: Is this the future of I/O for the RDBMS?

On 2021-05-02 14:49:44 +0100, Pól Ua Laoínecháin wrote: > While perusing the interweb, I stumbled on this very interesting blog > post from TiDB. > > > https://pingcap.com/blog/tikv-and-spdk-pushing-the-limits-of-storage-performance > > It talks about the Storage Performance Development Kit (SPD

Re: "invalid contrecord" error on replica

Hello, I encountered a similar issue with pg 13. TL;DR: The secondary did not received a wal record (CHECKPOINT_SHUTDOWN) which corrupted the wal and he failed when he tried to replay it. For a personal project I have a primary and a secondary with streaming replication and replication_slo