Christopher -
Thanks.
Answer 1:
I believe auto commit was off (but I'm not at my dev box right now). I'll
double-check that and the commit interval.
Answer 2:
Ah ha!! No indexes on FKs. I'll try that.
Yes, each baz is a uniquely identifiable. I had started a SP to create gen
the key but scra
John Pagakis kirjutas L, 25.10.2003 kell 10:16:
> Christopher -
> Thanks.
>
> Answer 1:
> I believe auto commit was off (but I'm not at my dev box right now). I'll
> double-check that and the commit interval.
>
> Answer 2:
> Ah ha!! No indexes on FKs. I'll try that.
>
> Yes, each baz is a uni
Bear with me all - working my way through this.
First of all, thanks for all the terrific advice. I think I focused you on
the inserts, when my *REAL* concern is the updates. Initially, I was
surmising that if the insert of 100,000 baz took an hour, an update to
customer_id of, say 1000 baz, wou
At 05:56 10/25/2003, John Pagakis wrote:
Snipping most of this, I only have one suggestion/comment to make.
[snip]
CREATE TABLE baz (
baz_key int4 NOT NULL,
baz_number CHAR(15) NOT NULL,
customer_id CHAR(39),
foobar_id INTEGER,
is_cancelled BOOL DEFAULT false NOT NULL,
cr
"John Pagakis" <[EMAIL PROTECTED]> writes:
> UPDATE baz SET customer_id = '1234' WHERE baz_key IN( SELECT baz_key FROM
> baz WHERE customer_id IS NULL LIMIT 1000 );
Do an "explain analyze" on this query. I bet it's doing two sequential scans.
Unfortunately in 7.3 the WHERE IN type of clause is p
Sean -
I believe auto-commit was off (not at the box right now). I'll play with
the commit interval; I know commits are expensive operations.
Thanks for item 2. I was toying with the notion of pre-creating 10
bazes off-loading them and then seeing if the COPY would be any faster; you
saved m
John Pagakis kirjutas L, 25.10.2003 kell 12:56:
> I wrote a JAVA simulation of the above that did 1000 updates in 37 seconds.
> That left me scratching my head because in psql when I did the
> semi-equivalent:
>
> UPDATE baz SET customer_id = '1234' WHERE baz_key IN( SELECT baz_key FROM
> baz WHE
Mark Wong wrote:
> > > Here are a pair of results where I just raise the load on the
> > > database, where increasing the load increases the area of the database
> > > touched in addition to increasing the transaction rate. The overall
> > > metric increases somewhat, but the response time for mos
