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

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

pgsql-performance by date

Next:From: Richard HuxtonDate: 2008-11-26 19:54:53
Subject: Re: Increasing pattern index query speed
Previous:From: AndrusDate: 2008-11-26 19:40:30
Subject: Re: Increasing pattern index query speed

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