COPY gets slower and slower and slower and.... - Mailing list pgsql-admin
From | chrisb |
---|---|
Subject | COPY gets slower and slower and slower and.... |
Date | |
Msg-id | 19990107143715.0bc1f477.in@mail.alphacsi.com Whole thread Raw |
List | pgsql-admin |
Hello Peoples, I found this post in the archives back in 10/98. I'm experiencing the same problem! Trying to copy approximately 500 megs (3.8 million records). Has anyone found a fix? Using Postgresql-v6.4.2, Linux 2.0.36 (Caldera OpenLinux). 256M RAM, (2) 9 gig UWSCSI HDS, Pentium II 400. Thanks in advance, ----------------------------- Chris Brinegar chrisb@mail.alphacsi.com << Message Signed at 2:44:01 PM Thursday, January 7, 1999 >> ----------------------------- >Re: [ADMIN] COPY slows down; is it normal? > > > > From: Daniele Orlandi <daniele@orlandi.com> > To: Bruce Momjian <maillist@candle.pha.pa.us>, >pgsql-hackers@postgreSQL.org, pgsql-admin@postgreSQL.org > Subject: Re: [ADMIN] COPY slows down; is it normal? > Date: Wed, 14 Oct 1998 01:33:01 +0200 > > > >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-admin by date: