Re: large database

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: large database
Дата
Msg-id 50C7B2F3.4000402@gmail.com
обсуждение исходный текст
Ответ на Re: large database  (Mihai Popa <mihai@lattica.com>)
Ответы Re: large database
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: large database
Следующее
От: "ac@hsk.hk"
Дата:
Сообщение: effective_cache_size and work_ram