From:
Michael Nolan <htfoot(at)gmail(dot)com>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Temporary tables under hot standby
Date:
2012-05-02 15:39:21
Message-ID:
CAOzAquLTBE_a2aRn-Cwsdiv_augWEhcCcPzbgqaBB8yO0oOYsQ@mail.gmail.com (view raw or flat )
Thread:
2012-04-25 03:55:15 from Noah Misch <noah(at)leadboat(dot)com>
2012-04-25 08:00:16 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 08:37:16 from Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
2012-04-25 09:10:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 10:08:23 from Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
2012-04-25 10:10:56 from Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
2012-04-25 11:16:16 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-05-01 20:12:20 from Jim Nasby <jim(at)nasby(dot)net>
2012-04-26 02:04:11 from Noah Misch <noah(at)leadboat(dot)com>
2012-04-26 04:57:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-26 08:18:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-26 13:57:59 from Greg Stark <stark(at)mit(dot)edu>
2012-04-26 14:12:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-25 08:04:54 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 15:49:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-25 16:08:05 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 16:18:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-25 16:19:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-25 16:30:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 16:53:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-25 17:31:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 18:34:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-26 07:56:40 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-26 12:14:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-26 14:12:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-04-26 14:22:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-05-02 15:14:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-05-02 15:39:21 from Michael Nolan <htfoot(at)gmail(dot)com>
2012-05-02 15:53:58 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2012-05-03 00:57:19 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-05-03 09:11:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-05-03 13:19:01 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-05-03 19:06:30 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-05-02 16:15:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-04-25 22:46:33 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-04-25 23:15:19 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2012-05-01 20:22:32 from Jim Nasby <jim(at)nasby(dot)net>
2012-04-26 02:16:11 from Noah Misch <noah(at)leadboat(dot)com>
2012-04-26 05:01:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-04-26 06:37:02 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-04-29 20:02:58 from Noah Misch <noah(at)leadboat(dot)com>
2012-06-08 17:26:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-06-08 17:38:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-06-08 18:05:24 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-06-10 17:24:31 from Noah Misch <noah(at)leadboat(dot)com>
2012-06-10 20:48:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-07 14:04:28 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-05-08 09:01:05 from Noah Misch <noah(at)leadboat(dot)com>
Lists:
pgsql-hackers
What is the use case for temporary tables on a hot standby server?
Perhaps this is a noobie question, but it seems to me that a hot standby
server's use by* applications* or *users* should be limited to transactions
that don't alter the database in any form.
However, I can see where temporary tables might be needed at the system
level (if not already available) in order to prepare more efficient plans
for some complex read-only queries.
--
Mike Nolan
In response to
Responses
pgsql-hackers by date
Next :From: Christopher BrowneDate: 2012-05-02 15:53:58Subject : Re: Temporary tables under hot standbyPrevious :From : Peter GeogheganDate : 2012-05-02 15:35:52Subject : Latch for the WAL writer - further reducing idle wake-ups.
