Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert performance for large transaction with multiple COPY FROM - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Insert performance for large transaction with multiple COPY FROM
Date
Msg-id CAGTBQparVsrQkLJ2di=NHKvdXgdVxPEePMaN=s=GkRxrvFx_kg@mail.gmail.com
Whole thread Raw
In response to Re: Insert performance for large transaction with multiple COPY FROM  (Horst Dehmer <horst.dehmer@gmail.com>)
Responses Re: Insert performance for large transaction with multiple COPY FROM  (Horst Dehmer <horst.dehmer@gmail.com>)
List pgsql-performance
Tree view 
On Sat, Jan 12, 2013 at 5:16 PM, Horst Dehmer <horst.dehmer@gmail.com> wrote:
> Yes, the ids is something I don't like either.
> They carry additional semantics, which I cannot make go away.
> How are chances char(20) is more time efficient than numeric(20)?
> Disk space is no problem here.

What are the other tables like then?

The exact data types involved are at issue here, so it matters.

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Insert performance for large transaction with multiple COPY FROM
Next
From: Tom Lane
Date:
Subject: Re: Insert performance for large transaction with multiple COPY FROM