PostgreSQL Performance - Re: Migration study, step 1: bulk write performance

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Migration study, step 1: bulk write performance

Michael Stone

2006-03-21, 7:28 am

On Tue, Mar 21, 2006 at 06:01:58AM -0600, Jim C. Nasby wrote:
>On Tue, Mar 21, 2006 at 12:56:18PM +0100, Steinar H. Gunderson wrote:
>
>Are you sure?

Yes. :) You actually shouldn't need metadata journaling in either
case--fsck will do the same thing. But fsck can take a *very* long time
on a large paritition, so for your data partition the journaling fs is a
big win. But your wal partition isn't likely to have very many files
and should fsck in a snap, and data consistency is taken care of by
synchronous operations. (Which is the reason you really don't need/want
data journalling.)

Mike Stone

---------------------------(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

Sponsored Links