From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | PostgreSQL - Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Cost of creating an emply WAL segment |
Date: | 2011-06-24 14:43:14 |
Message-ID: | 1308926594.2656.210.camel@lenovo01-laptop03.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
Has anyone measured the cost of creating empty WAL segments while the
database is running?
Actually, when is the new file created? Just after one segment is filled
up, or some time before then? What happens during WAL segment creation?
If there are pending transactions to be committed, do we see a delay?
I was looking at how Oracle manages this, and I was told that you can
create empty segments during installation, so I'm wondering whether it
might be a good addition to initdb or not:
initdb -S 30 -- create 30 empty segments during initdb
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2011-06-24 15:12:10 | Re: Long Running Update |
Previous Message | Kevin Grittner | 2011-06-24 14:00:23 | Re: Long Running Update |