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? >From our tests, having the file on the server can speed up the things by factor 2 or 3 in some cases. Also, using BINARY copy may give great benefits due to lower parsing overhead. As you say you're I/O bound, spreading tables, indices, wal and input file to different spindles won't help you much. HTH Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq