| From: | "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net> |
|---|---|
| To: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
| Cc: | Michael Riess <mlriess(at)gmx(dot)de>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 15,000 tables |
| Date: | 2005-12-01 18:49:43 |
| Message-ID: | 81A7970E-20C0-441A-9F21-4FC6D8759BF2@ehpg.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda pgsql-performance |
Here's a fairly recent post on reiserfs (and performance):
http://archives.postgresql.org/pgsql-novice/2005-09/msg00007.php
I'm still digging on performance of ext2 vrs journaled filesystems,
as I know I've seen it before.
Gavin
My point was not in doing an fsck, but rather in
On Dec 1, 2005, at 10:40 AM, Tino Wildenhain wrote:
> Am Donnerstag, den 01.12.2005, 10:07 -0800 schrieb Gavin M. Roy:
>> Hi Michael,
>>
>> I'm a fan of ReiserFS, and I can be wrong, but I believe using a
>> journaling filesystem for the PgSQL database could be slowing things
>> down.
>
> Have a 200G+ database, someone pulling the power plug
> or a regular reboot after a year or so.
>
> Wait for the fsck to finish.
>
> Now think again :-)
>
> ++Tino
>
Gavin M. Roy
800 Pound Gorilla
gmr(at)ehpg(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Barahona | 2005-12-01 18:53:00 | Consulta |
| Previous Message | Ron | 2005-12-01 18:48:11 | Re: 15,000 tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-01 18:57:33 | Re: 15,000 tables |
| Previous Message | Ron | 2005-12-01 18:48:11 | Re: 15,000 tables |