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
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