Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

From:	Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To:	Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:	David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Daniel Farina <daniel(at)heroku(dot)com>, "Harold A(dot) Giménez" <harold(dot)gimenez(at)gmail(dot)com>
Subject:	Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Date:	2012-07-23 13:04:46
Message-ID:	500D4BEE.7010205@ringerc.id.au
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2012-07-11 00:37:24 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>  2012-07-11 05:22:27 from Daniel Farina <daniel(at)heroku(dot)com>   2012-07-11 14:05:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2012-07-11 14:19:54 from "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>    2012-07-11 18:10:37 from Matthew Woodcraft <matthew(at)woodcraft(dot)me(dot)uk>     2012-07-12 01:23:16 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>    2012-07-11 20:18:32 from Craig James <cjames(at)emolecules(dot)com>     2012-07-11 20:47:21 from Shaun Thomas <sthomas(at)optionshouse(dot)com>      2012-07-11 21:04:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>     2012-07-11 21:32:33 from Mark Thornton <mthornton(at)optrak(dot)com>      2012-07-11 22:09:56 from Craig James <cjames(at)emolecules(dot)com>    2012-07-11 22:51:40 from Daniel Farina <daniel(at)heroku(dot)com>     2012-07-12 01:41:54 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>      2012-07-12 06:12:35 from Daniel Farina <daniel(at)heroku(dot)com>       2012-07-12 07:45:53 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>     2012-07-12 19:15:15 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>      2012-07-12 23:21:13 from Harold A(dot) Giménez <harold(dot)gimenez(at)gmail(dot)com>       2012-07-13 01:00:49 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>        2012-07-13 04:55:22 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com> 📎         2012-07-15 00:10:18 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com> 📎          2012-07-15 18:29:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2012-07-15 22:37:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2012-07-16 00:22:59 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>            2012-07-16 01:37:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2012-07-16 01:43:02 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>             2012-07-16 01:54:44 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>           2012-07-16 15:58:59 from Robert Haas <robertmhaas(at)gmail(dot)com>            2012-07-16 16:08:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2012-07-16 16:26:06 from Robert Haas <robertmhaas(at)gmail(dot)com>              2012-07-16 16:36:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2012-07-16 16:53:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                2012-07-16 16:57:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2012-07-16 18:39:58 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2012-07-16 19:03:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2012-07-16 19:18:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2012-07-16 19:26:38 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2012-07-16 19:46:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2012-07-17 22:56:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                     2012-07-17 23:48:50 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>                      2012-07-18 07:30:40 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>                     2012-07-18 00:13:19 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>                      2012-07-18 00:31:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2012-07-18 04:57:53 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>                        2012-07-18 06:00:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2012-07-24 13:33:26 from Greg Stark <stark(at)mit(dot)edu>                     2012-07-18 04:00:08 from Greg Smith <greg(at)2ndQuadrant(dot)com>                      2012-07-18 04:20:39 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>                      2012-07-18 05:56:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2012-07-18 12:26:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2012-07-18 21:45:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                     2012-07-23 04:37:33 from David Fetter <david(at)fetter(dot)org>                      2012-07-23 12:29:16 from Andrew Dunstan <andrew(at)dunslane(dot)net>                       2012-07-23 12:41:23 from David Fetter <david(at)fetter(dot)org>                        2012-07-23 12:56:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>                        2012-07-23 15:02:51 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>                       2012-07-23 13:04:46 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>                        2012-07-23 13:47:16 from Andrew Dunstan <andrew(at)dunslane(dot)net>                         2012-07-23 13:58:47 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>                  2012-07-18 03:22:22 from Greg Smith <greg(at)2ndQuadrant(dot)com>                2012-07-18 21:17:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2012-07-19 12:56:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2012-07-19 14:09:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2012-07-19 16:17:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2012-07-19 18:57:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2012-07-19 20:03:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2012-07-19 21:02:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2012-08-09 18:06:54 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>   2012-07-12 01:26:14 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Lists:	pgsql-hackers pgsql-performance

In response to

• Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation) at 2012-07-23 12:29:16 from Andrew Dunstan

Responses

• Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation) at 2012-07-23 13:47:16 from Andrew Dunstan

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andrew Dunstan	2012-07-23 13:47:16	Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous Message	Andrew Dunstan	2012-07-23 12:56:38	Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Martin French	2012-07-23 13:46:28	Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Previous Message	Andrew Dunstan	2012-07-23 12:56:38	Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)