t RAID 10, not RAID 0.
--
James Thornton
__
Internet Business Consultant, http://jamesthornton.com
---(end of broadcast)---
TIP 8: explain analyze is your friend
stripe width will
work well for the log files. In this case, the write operation will be
buffered in cache and the next log writes can be issued before the
previous write is destaged to disk."
--
James Thornton
__
e's no need to deallocate any blocks, and the underlying filesystem
metadata doesn't even get touched."
For further study, I have compiled a list of Linux filesystem resources
at: http://jamesthornton.com/hotlist/linux-filesystems/.
--
James Thornton
___
nto this before?
--
James Thornton
__
Internet Business Consultant, http://jamesthornton.com
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
j
0_same.pdf). Has
anyone delved into this before?
--
James Thornton
__
Internet Business Consultant, http://jamesthornton.com
---(end of broadcast)---
TIP 2: you can get off all lists at onc
tails on how to properly conduct a filesystem
benchmark and addresses scaling and load more so than Dr. Scalzo's tests.
For further study, I have compiled a list of Linux filesystem resources
at: http://jamesthornton.com/hotlist/linux-filesystems/.
--
James Thornton
__
per goes over the details on how to properly conduct a filesystem
benchmark and addresses scaling and load more so than Dr. Scalzo's tests.
For further study, I have compiled a list of Linux filesystem resources
at: http://jamesthornton.com/hotlist/linux-filesystems/.
--
James Thornton
__
slow, but this was
improved with XFS 1.1.
I think a journaling a FS is needed for PG data since large DBs could
take hours to recover on a non-journaling FS, but what about WAL files?
--
James Thornton
__
Internet Business Consultant, http