| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Siddharth Shah <siddharth(dot)shah(at)elitecore(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_xlog content |
| Date: | 2008-12-02 11:32:43 |
| Message-ID: | 49351CDB.7090605@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Siddharth Shah wrote:
> Hi,
>
> When I initialize database, pg_xlog direcory takes almost 17 MB size
> Why pg_xlog/WAL takes 17 MB of size while there is no transaction
> occurred ?
>
> What is the content of pg_xlog , If it's only wal file it's must be
> blank after on write of transaction on database.
It's the WAL. Files will be 16MB in size and you will have several (I
think 3 is the minimum). If you have a large update that can increase.
See the checkpoint_segments setting if you think that's something you'll
do frequently.
If you are using WAL-based replication you could have lots if the
archive command keeps failing.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-12-02 11:37:21 | Re: How do I index to speed up OVERLAPS? |
| Previous Message | A. Kretschmer | 2008-12-02 11:23:20 | Re: Executing a user created function twice give an error |