Skip site navigation (1) Skip section navigation (2)

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

From: "Daniel J(dot) Luke" <dluke(at)geeklair(dot)net>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Getting even more insert performance (250m+rows/day)
Date: 2006-05-30 19:59:19
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
On May 29, 2006, at 7:11 AM, Markus Schaber 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?

COPY table FROM STDIN using psql on the server

I should have gprof numbers on a similarly set up test machine soon ...
Daniel J. Luke
| *---------------- dluke(at)geeklair(dot)net ----------------* |
| *-------------- -------------* |
|   Opinions expressed are mine and do not necessarily   |
|          reflect the opinions of my employer.          |

In response to


pgsql-performance by date

Next:From: Scott MarloweDate: 2006-05-30 20:07:15
Subject: Re: Adding and filling new column on big table
Previous:From: WaldomiroDate: 2006-05-30 18:29:49

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group