| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Greg Smith <greg(at)2ndquadrant(dot)com> |
| Subject: | Re: SSDs with Postgresql? |
| Date: | 2011-04-21 15:44:04 |
| Message-ID: | 82bozza9tn.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Adrian Klaver:
>> Interesting. Is there an easy way to monitor WAL traffic in away? It
>> does not have to be finegrained, but it might be helpful to know if
>> we're doing 10 GB, 100 GB or 1 TB of WAL traffic on a particular
>> database, should the question of SSDs ever come up.
>
> They are found in $DATA/pg_xlog so checking the size of that
> directory regularly would get you the information.
But log files are recycled, so looking at the directory alone does not
seem particularly helpful.
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2011-04-21 15:49:56 | Re: How to realize ROW_NUMBER() in 8.3? |
| Previous Message | Adrian Klaver | 2011-04-21 15:42:43 | Re: SSDs with Postgresql? |