From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc:
Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: unlogged tables vs. GIST
Date:
2013-01-29 02:39:27
Message-ID:
CA+Tgmobya4Lvja+UyFo7-wxW2tyy6N0_=9_TSxaS0iyjp78Scw@mail.gmail.com (view raw or flat )
Thread:
2010-12-14 21:06:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-14 21:24:25 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-12-14 21:29:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-14 21:55:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-14 22:14:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-17 18:53:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-17 18:59:32 from Andy Colson <andy(at)squeakycode(dot)net>
2010-12-17 19:07:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-17 19:19:11 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-12-17 19:22:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-17 19:32:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-17 19:48:58 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-12-17 20:03:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-17 20:08:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-17 20:15:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-17 20:50:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-17 21:15:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-17 21:17:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-18 01:50:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-15 06:54:28 from Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
2013-01-15 18:10:05 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-15 18:33:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-15 18:44:37 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-15 18:48:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-15 18:53:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-15 18:58:00 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-15 19:07:37 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-15 20:56:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-15 21:26:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-15 21:54:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-23 09:04:11 from Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
2013-01-23 15:30:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-28 09:04:22 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-01-29 02:39:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-29 12:33:58 from Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
2013-02-11 06:44:26 from Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
2013-02-11 13:58:06 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-02-12 09:20:21 from Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com>
2010-12-17 19:25:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-17 19:31:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-17 19:33:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
On Mon, Jan 28, 2013 at 4:04 AM, Heikki Linnakangas
<hlinnakangas(at)vmware(dot)com> wrote:
> Do we need to do anything to unloggedLSN in pg_resetxlog?
Does the server go into recovery after pg_resetxlog? If so, no. If
not, probably, but I have no idea what. There's no "safe" value in
that case; what we ought to do is force a reset of all unlogged
relations, or just punt and hope nothing bad happens (which after all
is what pg_resetxlog is mostly about anyway).
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
Next :From: Robert HaasDate: 2013-01-29 02:41:16Subject : Re: Patches for TODO item: Avoid truncating empty OCDR temp tables on COMMITPrevious :From : Robert HaasDate : 2013-01-29 02:36:54Subject : Re: allowing privileges on untrusted languages
