Skip site navigation (1) Skip section navigation (2)

Re: extremly low memory usage

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: extremly low memory usage
Date: 2005-08-20 12:23:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Sat, Aug 20, 2005 at 02:17:54PM +0300, Marko Ristola wrote:
>Based on my knoledge, Ext3 is good with keeping filesystem integrity
>AND data integrity while pressing the reset button.  However, by
>selecting data=writeback, you gain more speed, but you risk the data
>integrity during a crash: Ext3 garantees only filesystem integrity.

That's why postgres keeps its own transaction log. Any of these
filesystems guarantee data integrity for data that's been synced to
disk, and postgres keeps track of what data has and has not been
committed so it can recover gracefully from a failure. That's why most
filesystems are designed the way they are; the application can determine
what things need better data integrity and which need better performance
on a case-by-case basis. 

Mike Stone

In response to


pgsql-performance by date

Next:From: Gavin SherryDate: 2005-08-20 13:08:13
Subject: Re: index as large as table
Previous:From: Michael StoneDate: 2005-08-20 12:18:33
Subject: Re: extremly low memory usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group