| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | jim(at)buttafuoco(dot)net |
| Cc: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Index location patch for review (more pgbench results) |
| Date: | 2001-09-13 00:49:13 |
| Message-ID: | 200109130049.f8D0nDb19964@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haroldo Stenger | 2001-09-13 04:34:10 | Need feedback: GeneXus will support PostgreSQL |
| Previous Message | Jim Buttafuoco | 2001-09-13 00:18:46 | Re: Index location patch for review (more pgbench results) |