From: | aklaver(at)comcast(dot)net (Adrian Klaver) |
---|---|
To: | Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: select count() out of memory |
Date: | 2007-10-28 16:35:03 |
Message-ID: | 102820071635.10028.4724BA37000E6D710000272C22007456729D0A900E04050E@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-------------- Original message ----------------------
From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
>
>
> 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
I'm thinking do a COPY to one large table. If the cost of indexing is relatively fixed as
you indicated in your previous post then you reduce the indexing overhead to each
COPY operation instead of each insert.
--
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2007-10-28 18:32:43 | pg_restore |
Previous Message | Tom Lane | 2007-10-28 15:46:57 | Re: Inheritance problem when restoring db |