On 26 Sep 2002 at 19:17, Justin Clift wrote:
> Shridhar Daithankar wrote:
> > 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
That's correct. Load the data so far and keep inserting data as and when it
They don't mind running against data so far. It's not very accurate stuff
> > 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.
I didn't know even that matters with SCSI..Will check out..
> 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.
That's OK for the reasons mentioned above. It wouldn't be out of place to
expect a UPS to such an installation...
Hoare's Law of Large Problems: Inside every large problem is a small problem
struggling to get out.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]