Re: Importing Large Amounts of Data

> 	 b) In fact, at times I don't need that data integrity. I'm
> prefectly
> 	 happy to risk the loss of a table during import, if it
> lets me do the
> 	 import more quickly, especially if I'm taking the database off line
> 	 to do the import anyway. MS SQL server in fact allows me to specify
> 	 relaxed integrity (with attendant risks) when doing a BULK
> IMPORT; it
> 	 would be cool if Postgres allowed that to.

Well I guess a TODO item would be to allow COPY to use relaxed constraints.
Don't know how this would go over with the core developers tho.

> Thanks. This is the kind of useful information I'm looking for. I
> was doing a vacuum after, rather than before, generating the indices.

That's because the indexes themselves are cleaned out with vacuum, as well
as the tables.

Chris