Re: 8.3devel slower than 8.2 under read-only load

On Nov 25, 2007 7:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> What about the table schemas?

The schema is in the dump. That's the main reason why I've sent the
dump to both of you.

Anyway, here it is:
db=# \d themelang              Table "public.themelang"     Column      |          Type          | Modifiers
------------------+------------------------+-----------codeth           | character varying(3)   | not nullcodelang
   | character varying(3)   | not nulllibtheme         | character varying(70)  | not nullmotsclesmetatags | character
varying(500)|descriptifmeta   | character varying(500) |motcleoverture_l | character varying(100) |motcleoverture_c |
charactervarying(100) |liencourt        | character varying(30)  |baselinetheme    | character varying(300)
|ordrenewsletter | integer                |
 
Indexes:   "pk_themelang" PRIMARY KEY, btree (codeth, codelang)

db=# \d vilsite                     Table "public.vilsite"      Column        |         Type          |     Modifiers
---------------------+-----------------------+--------------------codevil             | character varying(3)  | not
nullcodelang           | character varying(3)  | not nullcodepays            | character varying(3)  | not
nullregionwap          | character varying(3)  |codedep             | character varying(3)  |codetypevil         |
charactervarying(1)  | not nullouverte             | integer               | not nullcodeinteret         | character
varying(1) | not nullfamilleville        | character varying(1)  | not nullcodevilpostale      | character varying(8)
|capitale           | integer               | not nullcodemeteodirect     | character varying(5)  |libvilpubwoo
|character varying(10) |population          | integer               |codeinsee           | character varying(5)
|petiteville        | integer               | not null default 0logincommercial     | character varying(20)
|logincommercialprec| character varying(20) |
 
Indexes:   "pk_vilsite" PRIMARY KEY, btree (codevil)

db=# \d vilsitelang         Table "public.vilsitelang" Column  |         Type          | Modifiers
----------+-----------------------+-----------codevil  | character varying(3)  | not nullcodelang | character
varying(3) | not nulllibvil   | character varying(50) | not nulltrafic   | integer               |
 
Indexes:   "pk_vilsitelang" PRIMARY KEY, btree (codevil, codelang)
Foreign-key constraints:   "fk_vilsitel_vilsitela_vilsite" FOREIGN KEY (codevil) REFERENCES
vilsite(codevil) ON DELETE CASCADE

--
Guillaume