Re: [ADMIN] COPY slows down; is it normal?

Bruce Momjian wrote:
>
> What version is this? I would be interested to see if you see the same
> thing in 6.4 beta.

Postgresql 6.4, 13-Oct snapshot, importing about80MB of data *without* indexes
from a pg_dump. This is the size of the database file minute per minute starting
from about 13MB already imported:

-rw------- 1 postgres postgres 13434880 Oct 14 00:49 log2
-rw------- 1 postgres postgres 16015360 Oct 14 00:50 log2
-rw------- 1 postgres postgres 22765568 Oct 14 00:51 log2
-rw------- 1 postgres postgres 25034752 Oct 14 00:52 log2
-rw------- 1 postgres postgres 29212672 Oct 14 00:53 log2
-rw------- 1 postgres postgres 32923648 Oct 14 00:54 log2
-rw------- 1 postgres postgres 35717120 Oct 14 00:55 log2
-rw------- 1 postgres postgres 38363136 Oct 14 00:56 log2
-rw------- 1 postgres postgres 41394176 Oct 14 00:57 log2
-rw------- 1 postgres postgres 44310528 Oct 14 00:58 log2
-rw------- 1 postgres postgres 47063040 Oct 14 00:59 log2
-rw------- 1 postgres postgres 49176576 Oct 14 01:00 log2
-rw------- 1 postgres postgres 51142656 Oct 14 01:01 log2
-rw------- 1 postgres postgres 53305344 Oct 14 01:02 log2
-rw------- 1 postgres postgres 55394304 Oct 14 01:03 log2
-rw------- 1 postgres postgres 57581568 Oct 14 01:04 log2
-rw------- 1 postgres postgres 59236352 Oct 14 01:05 log2
-rw------- 1 postgres postgres 60784640 Oct 14 01:06 log2
-rw------- 1 postgres postgres 62578688 Oct 14 01:07 log2
-rw------- 1 postgres postgres 64389120 Oct 14 01:08 log2
-rw------- 1 postgres postgres 66199552 Oct 14 01:09 log2
-rw------- 1 postgres postgres 67723264 Oct 14 01:10 log2
-rw------- 1 postgres postgres 69140480 Oct 14 01:11 log2
-rw------- 1 postgres postgres 70656000 Oct 14 01:12 log2
-rw------- 1 postgres postgres 72122368 Oct 14 01:13 log2
-rw------- 1 postgres postgres 73596928 Oct 14 01:14 log2
-rw------- 1 postgres postgres 74883072 Oct 14 01:15 log2
-rw------- 1 postgres postgres 76201984 Oct 14 01:16 log2
-rw------- 1 postgres postgres 77692928 Oct 14 01:17 log2
-rw------- 1 postgres postgres 79175680 Oct 14 01:18 log2
-rw------- 1 postgres postgres 80650240 Oct 14 01:19 log2
-rw------- 1 postgres postgres 81821696 Oct 14 01:20 log2
-rw------- 1 postgres postgres 83042304 Oct 14 01:21 log2
-rw------- 1 postgres postgres 83574784 Oct 14 01:22 log2

As you may see, the speed decreases as the table size increases.

Bye!

--
Daniele

-------------------------------------------------------------------------------
"It's God. No, not Richard Stallman, or Linus Torvalds, but God."
(By Matt Welsh)
-------------------------------------------------------------------------------
Dal 28-09-1998, con un solo POP abbiamo fatto guadagnare a telecom italia
1769237 Lire solo in scatti alla risposta. Non male eh ?
-------------------------------------------------------------------------------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------