Re: select count() out of memory

From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
To: Adrian Klaver <aklaver(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select count() out of memory
Date: 2007-10-28 09:17:58
Message-ID: 472453C6.1040605@ifi.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rski 2007-10-28 11:58:17 plperl ubuntu problem
Previous Message Sebastjan Trepca 2007-10-28 08:53:03 Re: Inheritance problem when restoring db