Re: select count() out of memory - Mailing list pgsql-general

From Thomas Finneid
Subject Re: select count() out of memory
Date
Msg-id 472453C6.1040605@ifi.uio.no
Whole thread Raw
In response to Re: select count() out of memory  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general

Adrian Klaver wrote:
> I might be missing the point, but couldn't you do a Copy to a single table
> instead of multiple inserts and avoid the index overhead.

Are you saying, have one large table with indexes and do a COPY to it or
are you saying a one small empty table and do a COPY to it?

thomas

pgsql-general by date:

Previous
From: "Sebastjan Trepca"
Date:
Subject: Re: Inheritance problem when restoring db
Next
From: Perry Smith
Date:
Subject: Re: createdb argument question