Re: Sustained inserts per sec ... ?

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Christopher Petrilli" <petrilli(at)gmail(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: jd(at)commandprompt(dot)com, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sustained inserts per sec ... ?
Date: 2005-04-04 20:53:21
Message-ID: op.sop6y7v8th1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> This is done using COPY syntax, not INSERT syntax. So I suppose "yes"
> I do. The file that is being used for COPY is kept on a ramdisk.

COPY or psql \copy ?
If you wanna be sure you commit after each COPY, launch a psql in a shell
and check if the inserted rows are visible (watching SELECT count(*) grow
will do)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Petrilli 2005-04-04 20:56:26 Re: Sustained inserts per sec ... ?
Previous Message Christopher Petrilli 2005-04-04 20:18:42 Re: Sustained inserts per sec ... ?