On Mon, 10 May 1999, Tom Lane wrote:
>"Frank Morton" <fmorton@base2inc.com> writes:
>> Now that that is done, I thought I should dump the database
>> before doing any more to save those 7 days if I mess up.
>> After processing 18 HOURS doing the "pg_dump -d", it ran
>> out of memory and quit. Are there tools to do this differently,
[...]
>It does seem that your installation is remarkably slow; other people
>are working with tables exceeding 2Gb and don't seem unhappy about
Try 'copy': for cc. 170,000 records the import took me about 5-15
mins (I don't remember) on a P100 with 16MB of RAM. From the
insert-stuff it should not be a big deal to convert to tab-separated
text.
Circum
__ @
/ \ _ _ Engard Ferenc
l | ( \ / | | (\/) mailto:s-fery@kkt.sote.hu
\__/ | | \_ \_/ I I http://pons.sote.hu/~s-fery