Re: Postgres INSERT performance and scalability

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres INSERT performance and scalability
Date: 2011-09-20 01:32:41
Message-ID: 20110920013241.GR12765@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Jon Nelson (jnelson+pgsql(at)jamponi(dot)net) wrote:
> Isn't the WAL basically COW?

eh..? No.. The WAL is used to record what changes are made to the
various files in the database, it certainly isn't an kind of
"copy-on-write" system, where we wait until a change is made to data
before copying it..

If you INSERT .. SELECT, you're going to get the real data in the WAL,
and also in the heap of the new table..

Thanks,

Stephen

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Anibal David Acosta 2011-09-20 04:28:43 where is max_fsm_pages in PG9.0?
Previous Message Jon Nelson 2011-09-20 01:21:38 Re: Postgres INSERT performance and scalability