Re: Getting even more insert performance (250m+rows/day)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Daniel J. Luke" <dluke@xxxxxxxxxxxx>
Subject: Re: Getting even more insert performance (250m+rows/day)
From: Markus Schaber <schabi@xxxxxxxxxxxx>
Date: Mon, 29 May 2006 13:11:13 +0200
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <7E2D9162-867B-4DB1-B8A3-9ED701434488@xxxxxxxxxxxx>
Organization: Logical Tracking and Tracing International AG, Switzerland
References: <F6616E0E81AC0841B1F9DD252F7C4B55041A9A@xxxxxxxxxxxxxxxxxxxxxxxxxxx> <7E2D9162-867B-4DB1-B8A3-9ED701434488@xxxxxxxxxxxx>
User-agent: Debian Thunderbird 1.0.7 (X11/20051017)

Hi, Daniel,

Daniel J. Luke wrote:

> One big transaction every 5 minutes using 'COPY FROM' (instead of 
> inserts).

Are you using "COPY table FROM '/path/to/file'", having the file sitting
on the server, or "COPY table FROM STDIN" or psql "/copy", having the
file sitting on the client?

Follow-Ups:
- Re: Getting even more insert performance (250m+rows/day)
  - From: Daniel J. Luke

References:
- Re: Getting even more insert performance (250m+rows/day)
  - From: Larry Rosenman
- Re: Getting even more insert performance (250m+rows/day)
  - From: Daniel J. Luke

Prev by Date: Re: select with "like" from another table
Next by Date: Re: How can I make this query faster (resend)
Previous by thread: Re: Getting even more insert performance (250m+rows/day)
Next by thread: Re: Getting even more insert performance (250m+rows/day)
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux