From: Alvaro Herrera <alvherre@commandprompt.com>
To: Dave Crooke <dcrooke@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Stark <gsstark@mit.edu>
Cc: Pierre C <lists@peufeu.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Paul McGarry <paul@paulmcgarry.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Block at a time ...
Date: Tue, 16 Mar 2010 21:14:05 -0300
Message-ID: <20100317001405.GL3037@alvh.no-ip.org> (raw)
In-Reply-To: <ca24673e1003161658g6a0fa30dg2c158db395ac08@mail.gmail.com>
References: <ca24673e1003161658g6a0fa30dg2c158db395ac08@mail.gmail.com>
Dave Crooke escribió:
> An awesomely simple alternative is to just specify the extension as e.g. 5%
> of the existing table size .... it starts by adding one block at a time for
> tiny tables, and once your table is over 20GB, it ends up adding a whole 1GB
> file and pre-allocating it. Very little wasteage.
I was thinking in something like that, except that the factor I'd use
would be something like 50% or 100% of current size, capped at (say) 1 GB.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, dcrooke@gmail.com, tgl@sss.pgh.pa.us, gsstark@mit.edu, lists@peufeu.com, greg@2ndquadrant.com, paul@paulmcgarry.com
Subject: Re: Block at a time ...
In-Reply-To: <20100317001405.GL3037@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox