Re: [GENERAL] performance problem with loading data

2007-06-11 Thread Alban Hertroys
Sergey Karin wrote: > Hi all. > > I use PG 8.1.8 and PostGIS 1.1.1 > vka1=# select version(); > I develop application for loading geodata to database. In separate > transaction the application inserts the data in separate table that > created dynamically when transaction started. All tables has

Re: [GENERAL] performance problem with loading data

2007-06-09 Thread Dann Corbit
Try using COPY instead of insert select, if that is possible for you. It is much faster than insert. Otherwise, you might try dropping the index and constraint, loading the data, and recreating the index and constraint. From: [EMAIL PROTECTED] [mailto:[EMAI