Re: large database - Mailing list pgsql-general

From Adrian Klaver
Subject Re: large database
Date
Msg-id 50C7B2F3.4000402@gmail.com
Whole thread Raw
In response to Re: large database  (Mihai Popa <mihai@lattica.com>)
Responses Re: large database  (Nathan Clayton <nathanclayton@live.com>)
List 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@lattica.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.klaver@gmail.com


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: large database
Next
From: "ac@hsk.hk"
Date:
Subject: effective_cache_size and work_ram