On Sat, 2007-01-06 at 22:09 -0500, Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> >> cost is having to fsync the whole table afterwards.  So it really only
> >> makes sense for commands that one can expect are writing pretty much
> >> all of the table.  I could easily see it being a net loss for individual
> >> INSERTs.
> > What about multi value inserts? Just curious.
> I wouldn't want the system to assume that a multi-VALUES insert is
> writing most of the table.  Would you?  The thing is reasonable for
> inserting maybe a few hundred or few thousand rows at most, and that's
> still small in comparison to typical tables.

Good point. :)

Joshua D. Drake

>                       regards, tom lane

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to