Re: How filesystems matter with PostgreSQL - Mailing list pgsql-performance

From Ron Mayer
Subject Re: How filesystems matter with PostgreSQL
Date
Msg-id 4C0B455C.8050902@cheapcomplexdevices.com
Whole thread Raw
In response to Re: How filesystems matter with PostgreSQL  (Jon Schewe <jpschewe@mtu.net>)
Responses Re: How filesystems matter with PostgreSQL
List pgsql-performance
Jon Schewe wrote:

> OK, so if I want the 15 minute speed, I need to give up safety (OK in
> this case as this is just research testing), or see if I can tune
> postgres better.

Depending on your app, one more possibility would be to see if you
can re-factor the application so it can do multiple writes in parallel
rather than waiting for each one to complete.   If I understand right,
then many transactions could potentially be handled by a single fsync.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: How filesystems matter with PostgreSQL
Next
From: Craig Ringer
Date:
Subject: Re: How filesystems matter with PostgreSQL