Re: [GENERAL] Re: Slowdown problem when writing 1.7million records

2001-02-27 Thread Marc SCHAEFER
> Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC. I don't use Microsoft software, nor Java, but a few general suggestions for you: - you may want to create the INDEX at the end (using CREATE INDEX) in one operation - you may want to run your requests in trans

Re: [GENERAL] Re: Slowdown problem when writing 1.7million records

2001-02-27 Thread Gordan Bobic
> > I am very new to PostgreSQL and have installed v7.03 on a Red Hat Linux > > Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC. > > > > I have created a small file as follows: > > CREATE TABLE expafh ( > > postcode CHAR(8) NOT NULL, > > postcode_record_no INT, > > street