Statistics collection question

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Statistics collection question
Date: 2007-09-03 13:08:23
Message-ID: e373d31e0709030608h590e3d52t3efd8c3d19d28e28@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A couple of questions about the "most_common_vals" stuff in pg_stats
for a high traffic table:

1. Can I tell the stats collector to collect only values of a column
where a certain regex is matched? It is currently collecting the 500
values where most of them are values that I don't want, so it's
polluted with unwanted vals and therefore useless.

2. Secondly, for a unique column in the table, will the
"most_common_vals" always be -1? I guess this could make sense, but I
was wondering if the stats collector could somehow collect at least
1000 unique values to improve at least some performance.

TIA!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rainer Bauer 2007-09-03 13:26:19 Re: Cannot install under Windows Vista
Previous Message Andreas Tille 2007-09-03 13:04:48 Connecting to PostgreSQL server with Mono using ident authetication