Re: High Disk write and space taken by PostgreSQL

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: J Ramesh Kumar <rameshj1977(at)gmail(dot)com>
Cc: David Barton <dave(at)oneit(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: High Disk write and space taken by PostgreSQL
Date: 2012-08-16 15:49:53
Message-ID: CAOR=d=3YKXNWFr7eq2f+RK_tih=hH4m1bCwBzBpFFOmFqhv68w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 15, 2012 at 11:40 PM, J Ramesh Kumar <rameshj1977(at)gmail(dot)com> wrote:
> Dear Scott Marlowe,
>
> Thanks for the details.
>
> As you said, MySQL with MyISAM is better choice for my app. Because I don't
> need transaction/backup.

That's not exactly what I said. Remember that if you need to run
complex queries postgresql is still likely the better candidate.

> 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 ?

Unlogged tables as mentioned by others.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-08-16 16:04:12 Re: cluster on conditional index?
Previous Message Doug Hunley 2012-08-16 15:25:48 Re: cluster on conditional index?