Re: High memory usage / performance issue ( temp tables ? )

From: gmb <gmbouwer(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: High memory usage / performance issue ( temp tables ? )
Date: 2014-08-17 19:47:26
Message-ID: 1408304846514-5815126.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Something else I intended to ask in the original post, but forgot:

What effect , if any , will the autovacuum setting have in this type of
scenario ?
Will performance be improved by disabling this ?
I assume that a vacuum process will be required on at least the pg_catalog
due to dropping of temp tables during the process.

Regards

gmb

--
View this message in context: http://postgresql.1045698.n5.nabble.com/High-memory-usage-performance-issue-temp-tables-tp5815108p5815126.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2014-08-17 19:55:49 Re: High memory usage / performance issue ( temp tables ? )
Previous Message gmb 2014-08-17 10:40:21 Re: High memory usage / performance issue ( temp tables ? )