Re: Yet another Performance Question

In <OFFC4DA3D2.A3056D98-ON80256A32.00517540@cbis.com> martin.chantler@convergys.com writes:


>Have you tried running PostGres with the -F option so that
>disk flushes are not performed every time. Maybe this will make a
>difference
>to insert performance.
In the DBI-connect I still have a -F in the options, but now I am running
7.1RC2 (didn't have the time to do the upgrade to final yet). If this is
called differently now, please let me know

>NB In 7.1 this is replaced by WAL which I don't know much about

>MC


>--

>NOTICE:  The information contained in this electronic mail transmission is
>intended by Convergys Corporation for the use of the named individual or
>entity to which it is directed and may contain information that is
>privileged or otherwise confidential.  If you have received this electronic
>mail transmission in error, please delete it from your system without
>copying or forwarding it, and notify the sender of the error by reply email
>or by telephone (collect), so that the sender's address records can be
>corrected.



>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?

>http://www.postgresql.org/users-lounge/docs/faq.html

--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres