Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] How to drop stats on table - Mailing list pgsql-general

From Albe Laurenz
Subject Re: [ADMIN] How to drop stats on table
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50FE8202@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to How to drop stats on table  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
Responses Re: [ADMIN] How to drop stats on table  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alexander Shereshevsky
Date:
Subject: Re: How to drop stats on table
Next
From: Chris Richards
Date:
Subject: What could cause CREATE TEMP... "could not read block" error?