From: | "anarazel(at)anarazel(dot)de" <andres(at)anarazel(dot)de> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us>, Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com> |
Cc: | J Ramesh Kumar <rameshj1977(at)gmail(dot)com>,pgsql-performance(at)postgresql(dot)org |
Subject: | Re: High Disk write and space taken by PostgreSQL |
Date: | 2012-08-16 16:07:26 |
Message-ID: | d541296c-ddb4-44d6-b546-8dec81ae1fb8@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Bruce Momjian <bruce(at)momjian(dot)us> schrieb:
>On Thu, Aug 16, 2012 at 03:48:57PM +1000, Ondrej Ivanič wrote:
>> Hi,
>>
>> On 16 August 2012 15:40, J Ramesh Kumar <rameshj1977(at)gmail(dot)com>
>wrote:
>> > As you said, MySQL with MyISAM is better choice for my app. Because
>I don't
>> > need transaction/backup. May be I'll try with InnoDB and find the
>disk
>> > write/space difference. Is there any similar methods available in
>postgresql
>> > like MyISAM engine ?
>>
>> You can try unlogged tables:
>> http://www.postgresql.org/docs/9.1/static/sql-createtable.html
>>
>> If specified, the table is created as an unlogged table. Data written
>> to unlogged tables is not written to the write-ahead log (see Chapter
>> 29), which makes them considerably faster than ordinary tables.
>> However, they are not crash-safe: an unlogged table is automatically
>> truncated after a crash or unclean shutdown. The contents of an
>> unlogged table are also not replicated to standby servers. Any
>indexes
>> created on an unlogged table are automatically unlogged as well;
>> however, unlogged GiST indexes are currently not supported and cannot
>> be created on an unlogged table.
>
>I would set full_page_writes = off too.
Why? There shouldn't be any such writes on unlogged tables.
Andres
Please excuse the brevity and formatting - I am writing this on my mobile phone.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Vanns | 2012-08-16 16:14:36 | Re: Odd blocking (or massively latent) issue - even with EXPLAIN |
Previous Message | Jeff Janes | 2012-08-16 16:04:12 | Re: cluster on conditional index? |