Re: TPC-R benchmarks

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: TPC-R benchmarks
Date: 2003-10-02 16:22:20
Message-ID: 200310020922.20124.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Oleg,

> I ran VACUUM FULL ANALYZE yesterday and the re-ran the query with
> EXPLAIN ANALYZE.
> I got the same query plan and execution time.

How about my question? Those rows from pg_stats would be really useful in
diagnosing the problem.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2003-10-02 16:29:09 Re: TPC-R benchmarks
Previous Message Oleg Lebedev 2003-10-02 16:18:00 Re: TPC-R benchmarks