Postgres Pro
Downloads
Home   >   mailing lists

Re: problem with pg_statistics - Mailing list pgsql-performance

From Tom Lane
Subject Re: problem with pg_statistics
Date
Msg-id 24083.1056636485@sss.pgh.pa.us
Whole thread Raw
In response to problem with pg_statistics  (Andre Schubert <andre@km3.de>)
Responses Re: problem with pg_statistics
List pgsql-performance
Tree view 
Andre Schubert <andre@km3.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

pgsql-performance by date:

Previous
From: "Fernando Papa"
Date:
Subject: Re: Similar querys, better execution time on worst execution plan
Next
From: SZUCS Gábor
Date:
Subject: Re: Similar querys, better execution time on worst execution plan