pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
8.0.1 much slower than 7.4.2?
2+ messages / 2 participants
[nested] [flat]

* 8.0.1 much slower than 7.4.2?
@ 2005-04-04 10:21  anon permutation <anonpermutation@hotmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: anon permutation @ 2005-04-04 10:21 UTC (permalink / raw)
  To: pgsql-performance


Hi,

I have just upgraded our db from 7.4.2 to 8.0.1 and we are doing some 
testing.  For some reason, we have discovered that  our application performs 
much slower on 8.0.1.

My initial reaction was to turn on  log_min_duration_statement to see what's 
happening.  However, log_min_duration_statement does not work for JDBC 
clients in 8.0.1.

As a result, I modified log_statement to all.  Without my application doing 
anything, I see statements below being executed non-stop.  Who is triggering 
these statemetns?  Is this normal?  What am I doing wrong?

I am using Fedora Core 1 - Kernel: 2.4.22-1.2174.nptl

Please help.  Thanks.




2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
IKE '%nextval(%'





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: 8.0.1 much slower than 7.4.2?
@ 2005-04-14 23:03  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: anon permutation <anonpermutation@hotmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2005-04-14 23:03 UTC (permalink / raw)
  To: anon permutation <anonpermutation@hotmail.com>; +Cc: pgsql-performance


I would ask this on the jdbc mailling list.  They might know.

---------------------------------------------------------------------------

anon permutation wrote:
> 
> Hi,
> 
> I have just upgraded our db from 7.4.2 to 8.0.1 and we are doing some 
> testing.  For some reason, we have discovered that  our application performs 
> much slower on 8.0.1.
> 
> My initial reaction was to turn on  log_min_duration_statement to see what's 
> happening.  However, log_min_duration_statement does not work for JDBC 
> clients in 8.0.1.
> 
> As a result, I modified log_statement to all.  Without my application doing 
> anything, I see statements below being executed non-stop.  Who is triggering 
> these statemetns?  Is this normal?  What am I doing wrong?
> 
> I am using Fedora Core 1 - Kernel: 2.4.22-1.2174.nptl
> 
> Please help.  Thanks.
> 
> 
> 
> 
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT attnotnull FROM 
> pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
> 2005-04-04 18:05:00 CST PARSELOG:  statement: SELECT def.adsrc FROM 
> pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid
> ) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND 
> a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc L
> IKE '%nextval(%'
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-14 23:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-04 10:21 8.0.1 much slower than 7.4.2? anon permutation <anonpermutation@hotmail.com>
2005-04-14 23:03 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox