Re: a heavy duty operation on an "unused" table kills my server

From:	Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To:	Eduardo Piombino <drakorg(at)gmail(dot)com>
Cc:	Greg Smith <greg(at)2ndquadrant(dot)com>, Craig James <craig_james(at)emolecules(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject:	Re: a heavy duty operation on an "unused" table kills my server
Date:	2010-01-13 14:06:57
Message-ID:	4B4DD381.6070302@timbira.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-01-13 04:59:11 from Eduardo Piombino <drakorg(at)gmail(dot)com>  2010-01-13 05:14:00 from Craig James <craig_james(at)emolecules(dot)com>   2010-01-13 05:47:30 from Eduardo Piombino <drakorg(at)gmail(dot)com>    2010-01-13 06:02:02 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>     2010-01-13 07:03:04 from Eduardo Piombino <drakorg(at)gmail(dot)com>      2010-01-13 10:58:43 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>      2010-01-13 16:23:00 from Robert Haas <robertmhaas(at)gmail(dot)com>       2010-01-13 18:46:03 from Greg Smith <greg(at)2ndquadrant(dot)com>        2010-01-13 19:13:20 from Eduardo Piombino <drakorg(at)gmail(dot)com>         2010-01-14 20:49:04 from Eduardo Piombino <drakorg(at)gmail(dot)com>          2010-01-14 21:01:33 from Eduardo Piombino <drakorg(at)gmail(dot)com>           2010-01-15 22:32:32 from Greg Smith <greg(at)2ndquadrant(dot)com>            2010-01-16 00:47:35 from Eduardo Piombino <drakorg(at)gmail(dot)com>             2010-01-16 02:25:43 from Greg Smith <greg(at)2ndquadrant(dot)com>             2010-01-16 03:59:57 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>              2010-01-16 04:43:55 from Greg Smith <greg(at)2ndquadrant(dot)com>               2010-01-16 05:18:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2010-01-16 09:09:26 from Greg Smith <greg(at)2ndquadrant(dot)com>                 2010-01-16 12:49:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2010-01-16 17:47:10 from Greg Smith <greg(at)2ndquadrant(dot)com>                  2010-01-17 21:21:30 from Eduardo Piombino <drakorg(at)gmail(dot)com>                   2010-01-17 23:00:21 from Greg Smith <greg(at)2ndquadrant(dot)com>                    2010-01-17 23:14:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2010-01-14 05:36:54 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>        2010-01-14 14:49:36 from Andy Colson <andy(at)squeakycode(dot)net>         2010-01-14 18:07:44 from Greg Smith <greg(at)2ndquadrant(dot)com>          2010-01-14 18:15:33 from Andy Colson <andy(at)squeakycode(dot)net>           2010-01-14 18:30:46 from Greg Smith <greg(at)2ndquadrant(dot)com>            2010-01-15 10:55:00 from Matthew Wakeling <matthew(at)flymine(dot)org>             2010-01-15 17:09:46 from Craig James <craig_james(at)emolecules(dot)com>              2010-01-15 17:16:54 from Matthew Wakeling <matthew(at)flymine(dot)org>             2010-01-15 18:00:11 from Greg Smith <greg(at)2ndquadrant(dot)com>              2010-01-20 13:38:50 from Matthew Wakeling <matthew(at)flymine(dot)org>               2010-01-20 20:34:21 from Greg Smith <greg(at)2ndquadrant(dot)com>                2010-01-21 12:02:16 from Matthew Wakeling <matthew(at)flymine(dot)org>    2010-01-13 07:39:30 from Greg Smith <greg(at)2ndquadrant(dot)com>     2010-01-13 08:27:01 from Eduardo Piombino <drakorg(at)gmail(dot)com>      2010-01-13 14:06:57 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>       2010-01-13 15:53:59 from Eduardo Piombino <drakorg(at)gmail(dot)com>    2010-01-14 16:16:11 from Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>  2010-01-13 05:41:36 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>  2010-01-13 16:52:23 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>   2010-01-13 17:54:36 from Eduardo Piombino <drakorg(at)gmail(dot)com>    2010-01-13 18:11:32 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Lists:	pgsql-performance

In response to

• Re: a heavy duty operation on an "unused" table kills my server at 2010-01-13 08:27:01 from Eduardo Piombino

Responses

• Re: a heavy duty operation on an "unused" table kills my server at 2010-01-13 15:53:59 from Eduardo Piombino

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Tom Lane	2010-01-13 14:45:11	Re: [PERFORMANCE] work_mem vs temp files issue
Previous Message	Craig Ringer	2010-01-13 10:58:43	Re: a heavy duty operation on an "unused" table kills my server