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

1998-10-13 Thread Daniele Orlandi
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

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

1998-10-13 Thread Marc G. Fournier
On Tue, 6 Oct 1998, Gene Selkov Jr. wrote: Bruce Momjian wrote: What version is this? I would be interested to see if you see the same thing in 6.4 beta. It is 6.3.2, no patches applied. I will check it in 6.4, the latest versions I can see are postgresql.snapshot.tar.gz

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

1998-10-05 Thread Bruce Momjian
What version is this? I would be interested to see if you see the same thing in 6.4 beta. Thanks Daniele, thanks to everyone who replied, and to those who considered... Nothing helps. Disabling fsync does speed up COPY, but not with the table in question. It does not even seem to be the

[ADMIN] COPY slows down; is it normal?

1998-10-01 Thread Gene Selkov Jr.
Hi, I am watching the progress of a COPY from a 2 megarow table. It seems to slow down almost exponentially. The database file grew at about 2 megabytes a minute in the beginning and now, 20 hours since started, it grows at 80 kilobytes a minute. The table has 7 columns of char and int