From: Nick Fankhauser <nickf@ontko.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql-Performance@Postgresql. Org <pgsql-performance@postgresql.org>
Cc: Ray Ontko <rayo@ontko.com>
Subject: Re: n_distinct way off, but following a pattern.
Date: Sun, 16 Nov 2003 08:52:29 -0500
Message-ID: <NEBBLAAHGLEEPCGOBHDGKELCJHAA.nickf@ontko.com> (raw)
In-Reply-To: <5809.1068847947@sss.pgh.pa.us>
> It would be interesting to see exactly what inputs are going into this
> equation. Do you feel like adding some debug printouts into this code?
> Or just looking at the variables with a debugger? In 7.3 it's about
> line 1060 in src/backend/commands/analyze.c.
Tom-
I don't really have time to follow up at this moment, but I think this would
be interesting to look into, so I'll plan to dig into it over the
Thanksgiving Holiday when I'll have a little time free to follow up on some
fun projects. Your pointers should let me get into it pretty quickly.
In the meantime, I'll just set up a cron job that runs behind my nightly
analyze to put the correct numbers into pg_statistic on the tables that this
affects.
Thanks-
-Nick
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: nickf@ontko.com, tgl@sss.pgh.pa.us, rayo@ontko.com
Subject: Re: n_distinct way off, but following a pattern.
In-Reply-To: <NEBBLAAHGLEEPCGOBHDGKELCJHAA.nickf@ontko.com>
* 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