From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | User feedback requested on temp tables usage for Hot Standby |
Date: | 2011-10-27 23:13:30 |
Message-ID: | CA+U5nM+6uNXMN9osEvZ9fCWVTmvys44++QprvoMkCYrPpPnCNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Some people have asked for the ability to create temp tables on a Hot
Standby server.
I've got a rough implementation plan but it would have some
restrictions, so I would like to check my understanding of the use
case for this feature so I don't waste time implementing something
nobody actually finds useful.
My understanding is that the main use cases for that would be limited
to these two options only:
1. CREATE TEMP TABLE foo AS SELECT ....
2. CREATE TEMP TABLE foo (..);
INSERT INTO foo ...
and sometimes a TRUNCATE foo;
In almost all cases people don't run multiple INSERTs, nor do they run
UPDATEs or DELETEs, so the above actions would cover 99% of use cases.
Can anyone give backup to that opinion, or alternate viewpoints?
Thanks,
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2011-10-27 23:24:55 | Re: PostGIS in a commercial project |
Previous Message | Alan Hodgson | 2011-10-27 22:23:44 | Re: Server hitting 100% CPU usage, system comes to a crawl. |