Re: problem with pg_statistics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andre Schubert <andre(at)km3(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: problem with pg_statistics
Date: 2003-06-26 14:08:05
Message-ID: 24083.1056636485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Andre Schubert <andre(at)km3(dot)de> writes:
> i think i need a little help with a problem with pg_statistic.

Try reducing random_page_cost --- although you'd be foolish to set it on
the basis of just a single test query. Experiment with a few different
tables, and keep in mind that repeated tests will be affected by caching.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message SZUCS Gábor 2003-06-26 15:06:32 Re: Similar querys, better execution time on worst execution plan
Previous Message Fernando Papa 2003-06-26 13:33:38 Re: Similar querys, better execution time on worst execution plan