Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing for writes. Data integrity not critical - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Optimizing for writes. Data integrity not critical
Date
Msg-id 428D4146.6000203@familyhealth.com.au
Whole thread Raw
In response to Optimizing for writes. Data integrity not critical  (Steve Bergman <steve@rueb.com>)
Responses Re: Optimizing for writes. Data integrity not critical
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimizing for writes. Data integrity not critical
Next
From: "Joel Fradkin"
Date:
Subject: performance on a querry with many group by's any way to speed it up?