fsync, shared_buffers and sort_mem

From: Peter Peltonen <peter(dot)peltonen(at)fivetec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: fsync, shared_buffers and sort_mem
Date: 2002-02-26 20:27:58
Message-ID: 20020226222757.E2434@pihlaja.kotilo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm trying to do some performance tuning here and wanted to know a few
things:

- Is turning fsync off a good idea? What is the worst case that can happen
when it's turned off -- if PostgreSQL crashes does it mean just data
loss or can it corrupt the db's somehow too?

- How much should I leave shared memory for other apps than PostgreSQL?

- How does sort_mem affect performance?

Regards,
Peter

Browse pgsql-general by date

  From Date Subject
Next Message Zak Greant 2002-02-26 20:30:41 eWeek Poll: Which database is most critical to your organization?
Previous Message Robert Treat 2002-02-26 20:16:16 Re: Timestamp output