Re: Index location patch for review (more pgbench results) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Index location patch for review (more pgbench results)
Date
Msg-id 200109130049.f8D0nDb19964@candle.pha.pa.us
Whole thread Raw
In response to Re: Index location patch for review (more pgbench results)  ("Jim Buttafuoco" <jim@buttafuoco.net>)
List pgsql-hackers
> Moving the test to a system with SCSI disks gave different results. 
> There is NO difference between having the indexes on the same disk or 
> different disk with the data while running pgbench. So I leave it up to
> you guys as to include the patch or not.  I do believe that even if
> performance doesn't increase, this patch as alot of other benefits for
> admins.

I bet it is the SCSI tagged queueing that is making up for the same disk
performance.  Agreed administration is enough of a need to add the
feature.


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Jim Buttafuoco"
Date:
Subject: Re: Index location patch for review (more pgbench results)
Next
From: Haroldo Stenger
Date:
Subject: Need feedback: GeneXus will support PostgreSQL