| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Job <Job(at)colliniconsulting(dot)it>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Pg_bulkload and speed |
| Date: | 2015-04-29 22:43:19 |
| Message-ID: | 55415E87.5000509@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/29/15 4:24 AM, Job wrote:
> Hello!
>
> Due to speed up loading of a table of about 4 fields with 10 millions of record, are there some parameters to optimize?
> In same machine it takes about 15 minutes, in other machines about one hour.
There's a huge number of things that could account for this. Is
postgresql.conf the same? Same class of hardware? Same OS version? Same
filesystem? Same OS and filesystem configs? How are you actually loading
the data?
> Parallel mode is better than direct mode?
What 'parallel mode'?
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-04-29 22:47:14 | Re: clearing of the transactions shown in pg_locks |
| Previous Message | Jim Nasby | 2015-04-29 22:40:44 | Re: BDR Selective Replication |