Re: JFS fastest filesystem for PostgreSQL? - Mailing list pgsql-performance

From mudfoot@rawbw.com
Subject Re: JFS fastest filesystem for PostgreSQL?
Date
Msg-id 1121334993.42d636d187a3b@webmail.rawbw.com
Whole thread Raw
In response to JFS fastest filesystem for PostgreSQL?  ("Jeffrey W. Baker" <jwbaker@acm.org>)
List pgsql-performance

Quoting "Jeffrey W. Baker" <jwbaker@acm.org>:


>
> Here's the result, in transactions per second.
>
>               ext3  jfs  xfs
> ----------------------

-------
>  10 Clients     55   81   68
> 100 Clients     61  100   64
> ----------------------------

Was fsync true?  And have you tried ext2?  Legend has it that ext2 is the
fastest thing going for synchronous writes (besides O_DIRECT or raw) because
there's no journal.

>
> -jwb
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>



pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: slow joining very large table to smaller ones
Next
From: Michael Stone
Date:
Subject: Re: JFS fastest filesystem for PostgreSQL?