Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group