Re: Question / requests.

On 10/5/16 9:58 AM, Francisco Olarte wrote:
> Is the system catalog a bottleneck for people who has real use for
> paralell vacuum? I mean, to me someone who does this must have a very
> big db on a big iron. If that does not consist of thousands and
> thousands of smallish relations, it will normally be some very big
> tables and a much smaller catalog.

Not necessarily. Anyone that makes extensive use of temp tables can end 
up with a very large (and bloated) pg_attribute. AFAIK you can actually 
create "temp" versions of any object that lives in a schema by 
specifying pg_temp as the schema, but in practice I don't think you'll 
really see anything other than pg_attribute get really large. So it 
would be nice if pg_attribute could be done in parallel, but I suspect 
it's one of the catalog tables that could be causing these problems.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461