pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Wollny <Markus.Wollny@computec.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Date: Mon, 5 Dec 2005 15:44:54 +0100
Message-ID: <28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de> (raw)

 

> -----Ursprüngliche Nachricht-----
> Von: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Gesendet: Montag, 5. Dezember 2005 15:33
> An: Markus Wollny
> Cc: pgsql-performance@postgresql.org
> Betreff: Re: AW: [PERFORM] Queries taking ages in PG 8.1, 
> have been much faster in PG<=8.0 
 
> Could we see the pg_stats row for answer.session_id in both 
> 8.0 and 8.1?

Here you are:

select null_frac
	, avg_width
	, n_distinct
	, most_common_vals
	, most_common_freqs
	, histogram_bounds
	, Correlation
from pg_stats
where schemaname = 'survey'
and tablename = 'answer'
and attname = 'session_id';

8.1:
null_frac		0
avg_width		4
n_distinct		33513
most_common_vals	{1013854,1017890,1021551,1098817,764249,766938,776353,780954,782232,785985}
most_common_freqs	{0.001,0.001,0.001,0.001,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667}
histogram_bounds	{757532,819803,874935,938170,1014421,1081507,1164659,1237281,1288267,1331016,1368939}
Correlation		-0.0736492

8.0.3:
null_frac		0
avg_width		4
n_distinct		29287
most_common_vals	{765411,931762,983933,1180453,1181959,1229963,1280249,1288736,1314970,764901}
most_common_freqs	{0.001,0.001,0.001,0.001,0.001,0.001,0.001,0.001,0.001,0.000666667}
histogram_bounds	{757339,822949,875834,939085,1004782,1065251,1140682,1218336,1270024,1312170,1353082}
Correlation		-0.237136

Kind regards

   Markus



view thread (13+ messages)  latest in thread

Message-ID: <28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de>
Permalink:  ../28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de/
Also on:    postgresql.org/message-id/28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: Markus.Wollny@computec.de, tgl@sss.pgh.pa.us
  Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  In-Reply-To: <28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de>
  References: <28011CD60FB1724DBA4442E38277F6264A6BD5@hermes.computec.de>

* 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