Re: extremly low memory usage

From: Dan Harris
Subject: Re: extremly low memory usage
Date: ,
Msg-id: EFA54B85-504E-453A-972D-A7DD0E144763@drivefaster.net
(view: Whole thread, Raw)
In response to: Re: extremly low memory usage  (Jeremiah Jahn)
Responses: Re: extremly low memory usage  (Marko Ristola)
Re: extremly low memory usage  (Michael Stone)
List: pgsql-performance

Tree view

extremly low memory usage  (Jeremiah Jahn, )
 Re: extremly low memory usage  (John A Meinel, )
  Re: extremly low memory usage  (Jeremiah Jahn, )
   Re: extremly low memory usage  (John Arbash Meinel, )
 Re: extremly low memory usage  (Jeff Trout, )
  Re: extremly low memory usage  (Jeremiah Jahn, )
   Re: extremly low memory usage  (John Arbash Meinel, )
    Re: extremly low memory usage  (Ron, )
    Re: extremly low memory usage  (Jeremiah Jahn, )
     Re: extremly low memory usage  (John A Meinel, )
      Re: extremly low memory usage  (Ron, )
       Re: extremly low memory usage  (John A Meinel, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (Ron, )
          Re: extremly low memory usage  (Jeremiah Jahn, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (John A Meinel, )
          Re: extremly low memory usage  (Jeremiah Jahn, )
           Re: extremly low memory usage  (Ron, )
           Re: extremly low memory usage  (John A Meinel, )
         Re: extremly low memory usage  (Dan Harris, )
          Re: extremly low memory usage  (Marko Ristola, )
           Re: extremly low memory usage  (Michael Stone, )
            Re: extremly low memory usage  (Tom Lane, )
             Re: extremly low memory usage  (Marko Ristola, )
          Re: extremly low memory usage  (Michael Stone, )
      Re: extremly low memory usage  (Jeremiah Jahn, )
       Re: extremly low memory usage  (John A Meinel, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (Ron, )
          Re: extremly low memory usage  (John A Meinel, )
           Re: extremly low memory usage  (Jeremiah Jahn, )
            Re: extremly low memory usage  (John A Meinel, )
            Re: extremly low memory usage  (Ron, )
             Re: extremly low memory usage  (William Yu, )
             Re: extremly low memory usage  (Jeremiah Jahn, )
              Re: extremly low memory usage  (John A Meinel, )
 Re: extremly low memory usage  (Ron, )
 Re: extremly low memory usage  (Ron, )

On Aug 19, 2005, at 3:01 PM, Jeremiah Jahn wrote:

> Rebuild in progress with just ext3 on the raid array...will see if
> this
> helps the access times.

 From my recent experiences, I can say ext3 is probably not a great
choice for Pg databases.  If you check the archives you'll see
there's a lot of discussion about various journalling filesystems and
ext3 usually(always?) comes up on the bottom as far as performance
goes.  If you insist on using it, I would at least recommend the
noatime option in fstab and using data=writeback to get the faster of
the journal modes.

XFS seems to be a trusted choice, followed by Reiser and JFS both
with the occasional controversy when the comparisons pop up.

-Dan



pgsql-performance by date:

From: Gavin Sherry
Date:
Subject: Re: index as large as table
From: Tom Lane
Date:
Subject: Re: extremly low memory usage