Re: [ADMIN] COPY slows down; is it normal?
От | Daniele Orlandi |
---|---|
Тема | Re: [ADMIN] COPY slows down; is it normal? |
Дата | |
Msg-id | 3623E32D.7A757D6B@orlandi.com обсуждение исходный текст |
Ответ на | Re: [ADMIN] COPY slows down; is it normal? (Bruce Momjian <maillist@candle.pha.pa.us>) |
Список | pgsql-hackers |
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 -------------------------------------------------------------------------------
В списке pgsql-hackers по дате отправления: