Daniel J. Luke wrote: > On May 24, 2006, at 4:12 PM, Larry Rosenman wrote: >> are the batches single insert's, or within a big transaction? >> If the former, the latter is a big win. > > One big transaction every 5 minutes using 'COPY FROM' (instead of > inserts). > >> Also, what release(s) are you running? > > 8.1.x (I think we're upgrading from 8.1.3 to 8.1.4 today). > Had to ask :)
Also, is pg_xlog on the same or different spindles from the rest of the PG Data directory? LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
