| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Grzegorz Dostatni <dostatnig(at)yahoo(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Size on Disk |
| Date: | 2003-11-26 05:53:27 |
| Message-ID: | 11414.1069826007@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-docs pgsql-hackers |
Grzegorz Dostatni <dostatnig(at)yahoo(dot)com> writes:
> Currently the datase is roughly 80 Megs. About half of
> the size is stored in pg_xlog directory. I managed to
> figure out that those files are transaction log files?
> How can I delete them safely?
You can NOT. Don't even think about going there.
What you can do, if you intend only low-update-volume usage,
is reduce checkpoint_segments to reduce the number of WAL files
the system wants to keep around.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Bintintan | 2003-11-26 07:15:38 | Re: Sensitive sort problem? |
| Previous Message | Iain | 2003-11-26 05:41:15 | Re: A quick question about domains |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oli Sennhauser | 2003-11-26 17:40:18 | Re: Size on Disk |
| Previous Message | Grzegorz Dostatni | 2003-11-26 04:37:52 | Re: Size on Disk |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-26 06:38:44 | Re: A rough roadmap for internationalization fixes |
| Previous Message | Grzegorz Dostatni | 2003-11-26 04:37:52 | Re: Size on Disk |