Re: Error when inserting millions of records

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Error when inserting millions of records
Date: 2006-01-14 15:48:57
Message-ID: slrndsi7b9.1rvr.andrew+nonews@atlantis.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2006-01-13, Rudolph <rudolph(dot)froger(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Assad Jarrahian 2006-01-14 16:23:34 Re: sql (Stored procedure) design question
Previous Message Ottó Havasvölgyi 2006-01-14 13:38:07 Re: Moving PostgreSQL data directory on Windows