Re: Postgres INSERT performance and scalability

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* Jon Nelson (jnelson+pgsql@xxxxxxxxxxx) 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

Attachment: signature.asc
Description: Digital signature


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux