Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group