Re: [GENERAL] Copy command and import - MS SQL Server to Postgres

2004-11-05 Thread Allen Landsidel
On Fri, 5 Nov 2004 16:31:21 -0500, Goutam Paruchuri <[EMAIL PROTECTED]> wrote: > > Iam trying to import data from ms-sql server to postgres. I export the data > which has datetime columns in sql server using BCP. I use the following to > import back into postgres. > > copy tablename from 'c:\\bc

Re: [GENERAL] SCSI vs. IDE performance test

2003-10-28 Thread Allen Landsidel
Tom, this discussion brings up something that's been bugging me about the recommendations for getting more performance out of PG.. in particular the one that suggests you put your WAL files on a different physical drive from the database. Consider the following scenario: Database on drive1 WAL