Re: pg_dump / load seems really slow..

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chad <chadrosen(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump / load seems really slow..
Date: 2008-04-05 21:42:23
Message-ID: 9732.1207431743@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chad <chadrosen(at)gmail(dot)com> writes:
> export:

> pg_dump forums --data-only --no-owner -t foo > <output file>

> The load step seems really slow.

Don't use --data-only. Or if you must, look into dropping and
recreating indexes and foreign keys. See

http://www.postgresql.org/docs/8.3/static/populate.html

(or the corresponding page for whatever PG version you are using).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-05 21:47:04 Re: Text Search Configuration Problem
Previous Message Benoît Carpentier 2008-04-05 20:26:54 Benetl 1.7, free ETL tool using postgreSQL is out !!!