Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Getting even more insert performance (250m+rows/day)
- From: Markus Schaber <schabi(at)logix-tt(dot)com>
- To: "Daniel J. Luke" <dluke(at)geeklair(dot)net>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Getting even more insert performance (250m+rows/day)
- Date: Mon, 29 May 2006 13:11:13 +0200
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
- Re: Getting even more insert performance (250m+rows/day)
- 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
- Re: Getting even more insert performance (250m+rows/day)
- 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)
- Indexes: