Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration study, step 1: bulk write performance - Mailing list pgsql-performance

From Csaba Nagy
Subject Re: Migration study, step 1: bulk write performance
Date
Msg-id 1142942352.23597.8.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Migration study, step 1: bulk write performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
Tree view 
> For the record, that's the wrong way round. For the data partitioning
> metadata journaling is enough, and for the WAL partition you don't need any
> FS journaling at all.

Yes, you're right: the data partition shouldn't loose file creation,
deletion, etc., which is not important for the WAL partition where the
WAL files are mostly recycled... right ?

Cheers,
Csaba.

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: planner with index scan cost way off actual cost, advices to tweak cost constants?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Migration study, step 1: bulk write performance