Re: Temporary tables under hot standby
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Noah Misch <noah@leadboat.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-04-25T08:04:54Z
Lists: pgsql-hackers
On Wed, Apr 25, 2012 at 4:55 AM, Noah Misch <noah@leadboat.com> wrote: > A third patch will permit the following commands in read-only transactions, > where they will throw an error if the subject is not a temporary table: ... > VACUUM (including VACUUM FULL) > CLUSTER (without USING clause) > REINDEX Those commands have very low user visible effect on temp tables, so I suggest we implement them as no-op commands in HS. When everything else is done and dusted, they might be worth returning to, but I'd hope you won't spend much time on those anytime soon. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services