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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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.



pgsql-novice by date

Next:From: Dan CastidoDate: 2011-03-08 16:56:40
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-2017 The PostgreSQL Global Development Group