Mary Edie Meredith [EMAIL PROTECTED] writes:
Is there any option to remove the cost numbers from the plan so we can
just use diff to automate the plan comparisons?
No, but a few moments with sed or perl should get the job done for you.
regards, tom lane
[EMAIL PROTECTED] (Bruce Momjian) writes:
Tom Lane wrote:
Mary Edie Meredith [EMAIL PROTECTED] writes:
Stephan Szabo kindly responded to our earlier queries suggesting
we look at default_statistics_target and ALTER TABLE ALTER COLUMN
SET STATISTICS.
These determine the number of bins
On Thu, 11 Sep 2003, Tom Lane wrote:
Christopher Browne [EMAIL PROTECTED] writes:
The right answer for most use seems likely to involve:
a) Getting an appropriate number of bins (I suspect 10 is a bit
small, but I can't justify that mathematically), and
I suspect that also, but I
Tom Lane wrote:
Mary Edie Meredith [EMAIL PROTECTED] writes:
Stephan Szabo kindly responded to our earlier queries suggesting we look
at default_statistics_target and ALTER TABLE ALTER COLUMN SET
STATISTICS.
These determine the number of bins in the histogram for a given column.
Our port of OSDL DBT3 test suite to PostgreSQL (see Background
information below) is nearing completion. We would also like to confirm
our understanding of an outstanding consistency issue.
We have not been able to do meaningful kernel testing since the runs
(all parameters/kernels being equal)
On Thu, 2003-09-04 at 13:41, Mary Edie Meredith wrote:
Our port of OSDL DBT3 test suite to PostgreSQL (see Background
information below) is nearing completion. We would also like to confirm
our understanding of an outstanding consistency issue.
We have not been able to do meaningful kernel
On Thu, 2003-09-04 at 13:46, Rod Taylor wrote:
Run a VACUUM FULL ANALYZE between runs. This will force a full scan of
all data for stats
It will? Are you sure about that?
-Neil
---(end of broadcast)---
TIP 5: Have you checked our extensive
On Thu, 2003-09-04 at 19:50, Neil Conway wrote:
On Thu, 2003-09-04 at 13:46, Rod Taylor wrote:
Run a VACUUM FULL ANALYZE between runs. This will force a full scan of
all data for stats
It will? Are you sure about that?
You're right. According to the docs it won't.
I had a poor stats