Re: large database

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: mihai(at)lattica(dot)com
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: large database
Date: 2012-12-11 22:25:55
Message-ID: 50C7B2F3.4000402@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/11/2012 01:58 PM, Mihai Popa wrote:
> On Tue, 2012-12-11 at 10:00 -0800, Jeff Janes wrote:
>> On Mon, Dec 10, 2012 at 12:26 PM, Mihai Popa <mihai(at)lattica(dot)com> wrote:
>>> Hi,
>>>
>>> I've recently inherited a project that involves importing a large set of
>>> Access mdb files into a Postgres or MySQL database.
>>> The process is to export the mdb's to comma separated files than import
>>> those into the final database.
>>> We are now at the point where the csv files are all created and amount
>>> to some 300 GB of data.
>>
>> Compressed or uncompressed?
>
> uncompressed, but that's not much relief...
> and it's 800GB not 300 anymore. I still can't believe the size of this
> thing.

Are you sure the conversion process is working properly?

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fan, Yi 2012-12-12 01:21:01 Re: Looking for cooperators
Previous Message John R Pierce 2012-12-11 22:17:29 Re: large database