Re: [ADMIN] How to drop stats on table

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Sridhar N Bamandlapally *EXTERN*'" <sridhar(dot)bn1(at)gmail(dot)com>, "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ADMIN] How to drop stats on table
Date: 2015-11-20 12:24:53
Message-ID: A737B7A37273E048B164557ADEF4A58B50FE8202@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Sridhar N Bamandlapally wrote:
> is there any feature available in postgres to drop stats on table?

What about

DELETE FROM pg_catalog.pg_statistic WHERE starelid = <table oid>

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2015-11-20 12:46:50 Re: Problem with pg_hba.conf
Previous Message Alexander Shereshevsky 2015-11-20 12:10:30 Re: [GENERAL] How to drop stats on table

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-11-20 14:18:35 Re: What could cause CREATE TEMP... "could not read block" error?
Previous Message Alexander Shereshevsky 2015-11-20 12:10:30 Re: [GENERAL] How to drop stats on table