From:
Josh Berkus <josh(at)agliodbs(dot)com>
To:
daveg(at)sonic(dot)net
Cc:
Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Greg Stark <gsstark(at)mit(dot)edu>,
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Simon Riggs <simon(at)2ndQuadrant(dot)com>,
Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Eliminating VACUUM FULL WAS: remove flatfiles.c
Date:
2009-09-04 18:37:24
Message-ID:
4AA15E64.9020308@agliodbs.com (view raw or flat )
Thread:
2009-08-31 22:53:21 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-31 23:04:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-08-31 23:16:10 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-31 23:33:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-01 07:43:58 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-09-01 13:58:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-01 17:07:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-09-01 18:10:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-01 22:53:57 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-01 23:01:34 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-01 23:34:07 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-01 23:42:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-02 02:55:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-02 02:58:46 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-02 03:02:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-02 05:30:01 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
2009-09-02 13:55:36 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-02 17:41:59 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-09-02 17:46:59 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2009-09-02 17:52:11 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-02 17:57:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-09-02 19:01:06 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-02 18:01:02 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-09-02 18:07:04 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2009-09-02 18:31:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-02 18:54:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-02 19:10:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-02 19:30:26 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-02 19:45:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-03 00:37:16 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-02 19:49:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-02 20:03:19 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-02 20:37:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-02 20:39:51 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-02 20:42:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-02 22:54:36 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-02 20:13:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-02 18:31:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-02 19:04:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-03 23:39:59 from daveg <daveg(at)sonic(dot)net>
2009-09-03 23:57:25 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-09-04 00:12:01 from daveg <daveg(at)sonic(dot)net>
2009-09-04 18:37:24 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-09-04 18:48:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-04 18:53:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-04 19:10:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-04 19:27:24 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2009-09-04 19:28:18 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-04 19:36:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-04 20:01:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-05 01:28:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-05 01:37:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-05 03:03:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-31 20:36:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-31 22:58:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-04 20:37:39 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-09-04 20:43:09 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-04 20:54:28 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-09-04 21:00:53 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-04 21:27:19 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-09-04 21:01:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-04 19:01:27 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2009-09-16 06:33:40 from Andrew McNamara <andrewm(at)object-craft(dot)com(dot)au>
2009-09-01 23:56:52 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2009-09-02 01:29:33 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-02 02:56:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-02 22:55:19 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2009-09-03 00:31:11 from Greg Stark <gsstark(at)mit(dot)edu>
2009-09-02 01:34:58 from Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
Lists:
pgsql-hackers
All,
>>> I have a client who uses temp tables heavily, hundreds of thousands of
>>> creates
>>> and drops per day. They also have long running queries. The only
thing that
>>> keeps catalog bloat somewhat in check is vacuum full on bloated catalogs
>>> a few times a day. With
Actually, this is a good point ... if we dropped VACUUM FULL, we'd need
to also be able to call CLUSTER (or VACUUM REWRITE) on the system catalogs.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2009-09-04 18:48:42Subject : Re: Eliminating VACUUM FULL WAS: remove flatfiles.c Previous :From : Mark ReidDate : 2009-09-04 15:15:36Subject : 8.4: suppress_redundant_updates trigger vs. "Upsert" logic
