Re: [GENERAL] Run analyze on schema

2015-06-23 Thread Suresh Raja
On Mon, Jun 22, 2015 at 6:53 PM, Jerry Sievers wrote: > Suresh Raja writes: > > > Hi All: > > > > Does postgresql support schema analyze. I could not find > > analyze schema anywhere. Can we create a function to run > > analyze and reindex on all objects in the schema. Any > >

Re: [GENERAL] Run analyze on schema

2015-06-22 Thread Jerry Sievers
Suresh Raja writes: > Hi All: > > Does postgresql support schema analyze.  I could not find > analyze schema anywhere.  Can we create a function to run > analyze and reindex on all objects in the schema.  Any > suggestions or ideas. Yes "we" certainly can... begin; c