Re: Increasing pattern index query speed

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Increasing pattern index query speed
Date: 2008-11-26 19:45:27
Message-ID: ggk91c$rfa$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Is it OK to run
>
> ALTER TABLE rid ALTER COLUMN toode SET STATISTICS 1000
>
> in prod database or should I try to decrease 1000 to smaller value ?
> rid is big increasing table and is changed frequently, mostly by adding
> rows.

pgAdmin shows default_statistic_target value has its default value 10 in
postgresql.conf file

Andrus.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2008-11-26 19:54:53 Re: Increasing pattern index query speed
Previous Message Andrus 2008-11-26 19:40:30 Re: Increasing pattern index query speed