Re: [HACKERS] Btrfs clone WIP patch

2013-03-09 Thread Jonathan Rogers
Greg Smith wrote: > I think I can see how to construct such an example for the btrfs > version, but having you show that explicitly (preferably with a whole > sample session executing it) will also help reviewers. Remember: if > you want to get your submission off to a good start, the reviewer sh

Re: [HACKERS] Btrfs clone WIP patch

2013-02-28 Thread Jonathan Rogers
Phil Sorber wrote: > On Wed, Feb 13, 2013 at 5:48 PM, Josh Berkus wrote: >> On 02/13/2013 02:13 PM, Tom Lane wrote: >>> The big-picture question of course is whether we want to carry and >>> maintain a filesystem-specific hack. I don't have a sense that btrfs >>> is so widely used as to justify t

Re: [RFC] ideas for a new Python DBAPI driver (was Re: [HACKERS] libpq test suite)

2013-02-14 Thread Jonathan Rogers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 A number of the described features sound quite useful. Is it not practical to extend an existing library such as psycopg2? What method will you use to call libpq functions? As you are no doubt aware, psycopg2 uses the traditional CPython API but there

Re: [HACKERS] Btrfs clone WIP patch

2013-02-13 Thread Jonathan Rogers
Josh Berkus wrote: > On 02/13/2013 02:13 PM, Tom Lane wrote: >> The big-picture question of course is whether we want to carry and >> maintain a filesystem-specific hack. I don't have a sense that btrfs >> is so widely used as to justify this. > > If this is a valuable hack, it seems like it coul

Re: [HACKERS] Btrfs clone WIP patch

2013-02-13 Thread Jonathan Rogers
Tom Lane wrote: > Jonathan Rogers writes: >> This patch against PostgreSQL 9.1.8 takes advantage of efficient file >> cloning on Linux Btrfs file systems to make CREATE DATABASE operations >> extremely fast regardless of the size of the database used as a >> template.

[HACKERS] Btrfs clone WIP patch

2013-02-13 Thread Jonathan Rogers
This patch against PostgreSQL 9.1.8 takes advantage of efficient file cloning on Linux Btrfs file systems to make CREATE DATABASE operations extremely fast regardless of the size of the database used as a template. On my system, I can create a database from a multi-gibibyte template in a second or