[GENERAL] How to use postgres 7.0.3 with -F?

2001-02-16 Thread Konstantinos Agouros
Hi, someone gave me the tip to use the -F-flag to improve performance. Since I can't run the postmaster with -F but just postgres how do I do it, if I want to import a big amount of data? Konstantin -- Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTECTED] Otkerstr. 28,

Re: [GENERAL] How to use postgres 7.0.3 with -F?

2001-02-16 Thread Tom Lane
[EMAIL PROTECTED] (Konstantinos Agouros) writes: someone gave me the tip to use the -F-flag to improve performance. Since I can't run the postmaster with -F but just postgres how do I do it, if I want to import a big amount of data? In 7.0.* (but not prior versions) it is safe to run

Re: [GENERAL] How to use postgres 7.0.3 with -F?

2001-02-16 Thread Konstantinos Agouros
In [EMAIL PROTECTED] [EMAIL PROTECTED] (Tom Lane) writes: [EMAIL PROTECTED] (Konstantinos Agouros) writes: someone gave me the tip to use the -F-flag to improve performance. Since I can't run the postmaster with -F but just postgres how do I do it, if I want to import a big amount of data?

Re: [GENERAL] How to use postgres 7.0.3 with -F?

2001-02-16 Thread Tom Lane
[EMAIL PROTECTED] (Konstantinos Agouros) writes: export PGOPTIONS="-F" psql mydb A O thanks for the help I was confused. Does this also work that way, if I use it from DBI::Pg from perl? Like setting $ENV{'PGOPTIONS'} Yeah, I think that should work if you do it before opening a

Re: [GENERAL] How to use postgres 7.0.3 with -F?

2001-02-16 Thread Doug McNaught
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Konstantinos Agouros) writes: export PGOPTIONS="-F" psql mydb A O thanks for the help I was confused. Does this also work that way, if I use it from DBI::Pg from perl? Like setting $ENV{'PGOPTIONS'} Yeah, I think that