Re: Error when inserting millions of records - Mailing list pgsql-general

From Andrew - Supernews
Subject Re: Error when inserting millions of records
Date
Msg-id slrndsi7b9.1rvr.andrew+nonews@atlantis.supernews.net
Whole thread Raw
Responses Re: Error when inserting millions of records  ("Rudolph" <rudolph.froger@gmail.com>)
List pgsql-general
On 2006-01-13, Rudolph <rudolph.froger@gmail.com> wrote:
> Me and a friend are testing some operations for a search application in
> PostgreSQL. In version 8.1 my friend tried to copy the result of a join
> into another table, about 45.000.000 (small) records. This is the
> result:

Do you have any constraints, especially deferred constraints, or triggers
on the table? Are there any functional indexes?

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

pgsql-general by date:

Previous
From: Ottó Havasvölgyi
Date:
Subject: Re: Moving PostgreSQL data directory on Windows
Next
From: Assad Jarrahian
Date:
Subject: Re: sql (Stored procedure) design question