Re: Optimizing for writes. Data integrity not critical

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Steve Bergman <steve(at)rueb(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimizing for writes. Data integrity not critical
Date: 2005-05-20 01:45:42
Message-ID: 428D4146.6000203@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I'm doing the writes individually. Is there a better way? Combining
> them all into a transaction or something?

Use COPY of course :)

Or at worst bundle 1000 inserts at a time in a transation...

And if you seriously do not care about your data at all, set fsync = off
in you postgresql.conf for a mega speedup.

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joel Fradkin 2005-05-20 19:47:21 performance on a querry with many group by's any way to speed it up?
Previous Message Tom Lane 2005-05-19 23:45:01 Re: Optimizing for writes. Data integrity not critical