Re: How filesystems matter with PostgreSQL

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Jon Schewe <jpschewe(at)mtu(dot)net>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How filesystems matter with PostgreSQL
Date: 2010-06-06 06:51:08
Message-ID: 4C0B455C.8050902@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2010-06-06 07:48:19 Re: How filesystems matter with PostgreSQL
Previous Message Scott Marlowe 2010-06-06 03:34:08 Re: How filesystems matter with PostgreSQL