Re: [PERFORM] file system and raid performance

On Mon, 4 Aug 2008, Mark Wong wrote: Hi all, We've thrown together some results from simple i/o tests on Linux comparing various file systems, hardware and software raid with a little bit of volume management: http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide What I'd like to

[PERFORM] file system and raid performance

Hi all, We've thrown together some results from simple i/o tests on Linux comparing various file systems, hardware and software raid with a little bit of volume management: http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide What I'd like to ask of the folks on the list is how rele

Re: [PERFORM] Posible planner improvement?

>>> On Mon, May 26, 2008 at 6:30 AM, ITAGAKI Takahiro <[EMAIL PROTECTED]> wrote: > Albert Cervera Areny <[EMAIL PROTECTED]> wrote: > >> I've got a query similar to this: >> >> select * from t1, t2 where t1.id > 158507 and t1.id = t2.id; >> >> That took > 84 minutes (the query was a bit longer

Re: [PERFORM] SSD Performance Article

Scott Marlowe wrote: On Thu, Jul 31, 2008 at 11:45 AM, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote: Interesting read... http://www.linux.com/feature/142658 Wish he had used a dataset larger than 1G... Wish he had performed a test with the index on a dedicated SATA. HH --