> 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.
In response to
pgsql-performance by date
|Next:||From: Joel Fradkin||Date: 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 Lane||Date: 2005-05-19 23:45:01|
|Subject: Re: Optimizing for writes. Data integrity not critical |