In <[EMAIL PROTECTED]> [EMAIL PROTECTED]
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 (d
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.
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 tran
Konstantinos Agouros <[EMAIL PROTECTED]> said:
> On Wed, Apr 18, 2001 at 02:59:53PM +0200, Patrik Kudo wrote:
> > Hi!
> >
> > I'm not 100% sure, but I think it would be much faster if you use COPY
> > instead of INSERT when you read in a lot of data from a file.
> Well unless I am the database o
On Wed, Apr 18, 2001 at 02:59:53PM +0200, Patrik Kudo wrote:
> Hi!
>
> I'm not 100% sure, but I think it would be much faster if you use COPY
> instead of INSERT when you read in a lot of data from a file.
Well unless I am the database owner I only can do \copy and the script does
some manipulati
Hi!
I'm not 100% sure, but I think it would be much faster if you use COPY
instead of INSERT when you read in a lot of data from a file.
Regards,
Patrik Kudo
--
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Wed, 18 Apr 2001, Konstantinos Agou
On Wed, Apr 18, 2001 at 12:55:07PM +0200, Konstantinos Agouros wrote:
> I once read in Oracle Performance Tuning, that if one inserts or changes large
> amounts of data in a table, it might be better to drop indices before doing
> this and recreating them afterwards. Could someone give a hint on
On Wed, Apr 18, 2001 at 07:18:40AM -0500, Len Morgan wrote:
> >I once read in Oracle Performance Tuning, that if one inserts or changes
> large
> >amounts of data in a table, it might be better to drop indices before doing
> >this and recreating them afterwards. Could someone give a hint on how th
>I once read in Oracle Performance Tuning, that if one inserts or changes
large
>amounts of data in a table, it might be better to drop indices before doing
>this and recreating them afterwards. Could someone give a hint on how this
>is in Postgres 7.1? Currently I am experiencing a massive slowdo
Hi,
I once read in Oracle Performance Tuning, that if one inserts or changes large
amounts of data in a table, it might be better to drop indices before doing
this and recreating them afterwards. Could someone give a hint on how this
is in Postgres 7.1? Currently I am experiencing a massive slowd