Skip site navigation (1) Skip section navigation (2)

Keeping separate WAL segments for each database

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: PostgreSQL Hackers ML <pgsql-hackers(at)postgresql(dot)org>
Subject: Keeping separate WAL segments for each database
Date: 2010-06-30 18:54:06
Message-ID: 1277924046.2965.60.camel@hp-laptop2.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-hackers
I talked to Sybase people about their latest technologies. Many features
that shipped with their latest ASE 15.5 product has been in PostgreSQL
since many years (like functional indexes, etc). :)

One of the things that interested me was parallel recovery feature. They
said that they are keeping separate xlogs for each database, which
speeds ups recovery in case of a crash. It also would increase
performance, since we could write xlogs to separate disks.

Is that doable for PostgreSQL, too?
-- 
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2010-06-30 19:08:16
Subject: Re: Keepalive for max_standby_delay
Previous:From: Simon RiggsDate: 2010-06-30 18:34:49
Subject: Re: Admission Control

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group