pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: anon permutation <anonpermutation@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.0.1 much slower than 7.4.2?
Date: Thu, 14 Apr 2005 19:03:01 -0400 (EDT)
Message-ID: <200504142303.j3EN31D18018@candle.pha.pa.us> (raw)
In-Reply-To: <BAY106-F322ECF183423A7CDCD7EACB73B0@phx.gbl>


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



view thread (2+ messages)

Message-ID: <200504142303.j3EN31D18018@candle.pha.pa.us>
Permalink:  ../200504142303.j3EN31D18018@candle.pha.pa.us/
Also on:    postgresql.org/message-id/200504142303.j3EN31D18018@candle.pha.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pgman@candle.pha.pa.us, anonpermutation@hotmail.com
  Subject: Re: 8.0.1 much slower than 7.4.2?
  In-Reply-To: <200504142303.j3EN31D18018@candle.pha.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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