Re: JFS fastest filesystem for PostgreSQL?

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
>