[PERFORM] pg_restore taking 4 hours!

arameters are the default) tcpip_socket = true max_connections = 30 shared_buffers = 3 sort_mem = 4096 vacuum_mem = 8192 max_fsm_pages = 2 max_fsm_relations = 1000 Regards, Rodrigo Carvalhaes ---(end of broadcast)--- TIP 6: Have you s

Re: [PERFORM] pg_restore taking 4 hours!

prove this performance? Cheers (and thanks for all the oppinions) Rodrigo Carvalhaes dadosadv=# \d sb1010 Table "public.sb1010" Column | Type |

Re: [PERFORM] Improve BULK insertion

Hi! 1. I am doing the inserts using pg_restore. The dump was created using pg_dump and the standard format (copy statements) 2. See below the table schema. There are only 7 indexes. 3. My transaction log configuration are : checkpoint_segments = 3 and checkpoint_timeout = 300 and my transactio