Re: [PERFORM] Copy performance issues

2010-08-18 Thread s anwar
On Wed, Aug 18, 2010 at 3:42 PM, Tom Lane wrote: > Saadat Anwar writes: > > I am having severe COPY performance issues after adding indices. What > used > > to take a few minutes (without indices) now takes several hours (with > > indices). I've tried to tweak the database configuration (based o

[PERFORM] Copy performance issues

2010-08-18 Thread s anwar
I am having severe COPY performance issues after adding indices. What used to take a few minutes (without indices) now takes several hours (with indices). I've tried to tweak the database configuration (based on Postgres documentation and forums), but it hasn't helped as yet. Perhaps, I haven't inc