| From: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [ADMIN] How to drop stats on table |
| Date: | 2015-11-21 07:24:53 |
| Message-ID: | CAGuFTBXZr+Ab3Qnw9M-MZu=k8qh_p23UqhrnZW8vVYZmhC6bLw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
the actual issue is, when
1. temp table <say tmp1>is created with rows
2. stats/analyze on table (tmp1)
3. table dropped (tmp1)
but in stats related catalog tables a blot is created
In this scenario, thousands of temp tables created per day, blots are
increasing and stats related tables are growing to 10's of GB
however, we schedule vacuum on catalog tables to control size
the worry is, catalog tables also undergo MVCC concept
I think when table is dropped, should have option to remove or reuse
related blot-space on catalog tables
-Sridhar
On Fri, Nov 20, 2015 at 5:54 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
wrote:
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-11-21 15:17:25 | Re: [ADMIN] How to drop stats on table |
| Previous Message | 許耀彰 | 2015-11-21 00:55:34 | Re: [BUGS] postgresql downgrade issue |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-11-21 15:17:25 | Re: [ADMIN] How to drop stats on table |
| Previous Message | Jim Nasby | 2015-11-21 06:13:15 | Re: postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data. |