| From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | "psql performance list" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | filesystem options for WAL |
| Date: | 2008-07-06 05:04:31 |
| Message-ID: | 3073cc9b0807052204j14efa56ft113b50013cacddcf@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
Here http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm I read:
"""
Combining these two, an optimal fstab for the WAL might look like this:
/dev/hda2 /var ext3 defaults,writeback,noatime 1 2
"""
Is this info accurate?
I also read on other document from the "technical documentation" that
for partitions where you have the tables and indexes is better to have
journaling and for partitions for the WAL is better to not have
journalling...
i tought it has to be the other way (tables & indices without
journalling, WAL with journalling)
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-07-06 06:04:36 | Re: How much work_mem to configure... |
| Previous Message | Sergio Gabriel Rodriguez | 2008-07-05 12:14:05 | Re: Subquery WHERE IN or WHERE EXISTS faster? |