Hi Shridhar, Shridhar Daithankar wrote: <snip> > 3) Any suggsestions for runtime as data load and query will be going in > parallel.
That sounds unusual. From reading this, it *sounds* like you'll be running queries against an incomplete dataset, or maybe just running the queries that affect the tables loaded thus far (during the initial load). <snip> > fsync=true (Sad but true. Left untouched.. Will that make a difference on > SCSI?) Definitely. Have directly measured a ~ 2x tps throughput increase on FreeBSD when leaving fsync off whilst performance measuring stuff recently (PG 7.2.2). Like anything it'll depend on workload, phase of moon, etc, but it's a decent indicator. <snip> > Now questions. > > 1) Instead of copying from a single 12GB data file, will a parallel copy from > say 5 files will speed up the things? Not sure yet. Haven't get done enough performance testing (on the cards very soon though). > Couple MB of data per sec. to disk is just not saturating it. It's a RAID 5 > setup.. fsync = off would help during the data load, but not a good idea if you're going to be running queries against it at the same time. Am still getting the hang of performance tuning stuff. Have a bunch of Ultra160 hardware for the Intel platform, and am testing against it as time permits. Not as high end as I'd like, but it's a start. :-) Regards and best wishes, Justin Clift <snip> > Bye > Shridhar -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
