Re: Block at a time ... - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Block at a time ...
Date
Msg-id 20100317001405.GL3037@alvh.no-ip.org
Whole thread Raw
In response to Block at a time ...  (Dave Crooke <dcrooke@gmail.com>)
Responses Re: Block at a time ...
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Dave Crooke
Date:
Subject: Block at a time ...
Next
From: Rob Wultsch
Date:
Subject: Building multiple indexes concurrently