pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joel Fradkin <jfradkin@wazagua.com>
To: PostgreSQL Perform <pgsql-performance@postgresql.org>
Subject: FW: speed of querry?
Date: Mon, 18 Apr 2005 09:00:48 -0400
Message-ID: <000401c54416$a4e57e80$797ba8c0@jfradkin> (raw)


What are the statistics
for tbljobtitle.id and tbljobtitle.clientnum 
I added default_statistics_target = 250 to the config and re-loaded the data
base. If that is what you mean?

--- how many distinct values of each, 

tbljobtitle.id 6764 for all clients 1018 for SAKS
tbljobtitle.clientnum 237 distinct clientnums just 1 for SAKS

and are the distributions skewed to a few popular values?
There are 3903 distinct values for jobtitle

Not sure if I answered the questions, let me know if you need more info.
It appears there are 1018 job titles in the table for saks and 6764 for all
the clients. There can be more values as presentation layer can have more
then one value for an id. SAKS is not using presentation layer yet as there
are only 1018 distinct values 1 for each id.

Joel






view thread (22+ messages)  latest in thread

Message-ID: <000401c54416$a4e57e80$797ba8c0@jfradkin>
Permalink:  ../000401c54416$a4e57e80$797ba8c0@jfradkin/
Also on:    postgresql.org/message-id/000401c54416$a4e57e80$797ba8c0@jfradkin

 · 

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: jfradkin@wazagua.com
  Subject: Re: FW: speed of querry?
  In-Reply-To: <000401c54416$a4e57e80$797ba8c0@jfradkin>

* 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