Skip site navigation (1) Skip section navigation (2)

Re: Simple table creation

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: cjbarnes18(at)gmail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Simple table creation
Date: 2011-03-08 14:24:49
Message-ID: AANLkTimN7zNWNSmi9T7u6PgACAOM4=NiHq9biqPqATJm@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Craig,

1. ODBC is not fast by nature adding a layer on top of the direct access
libraries. Can you dump from cobol to text delimited file (or fixed length)
and then up into Postgres ?

2. when you say 'Raises an error': what error do you get ?

3. 4 millions rows seems like a fairly sizeable amount of data, have you
checked you have enough space on the disk where the Postgres DB resides ?

4. Can't you do your upload piece by piece; I would have thought that out of
the n millions rows, a large chunk are historical data which do not need to
be exported on a daily basis.

Didier

Responses

pgsql-novice by date

Next:From: Dan CastidoDate: 2011-03-08 16:56:40
Subject:
Previous:From: Didier Gasser-MorlayDate: 2011-03-08 14:20:06
Subject: Re: psql doesn't see externally created db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group