Bruce Momjian <bruce@xxxxxxxxxx> 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@xxxxxxxxx> >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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
