Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-08-02 Thread Alon Goldshuv
Tom, Thanks for pointing it out. I made the small required modifications to match copy.c version 1.247 and sent it to -patches list. New patch is V16. Alon. On 8/1/05 7:51 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > "Alon Goldshuv" <[EMAIL PROTECTED]> writes: >>> This patch appears to reverse

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-08-01 Thread Alon Goldshuv
Tom, >> I've attached it here, sorry to the list owner for the patch inclusion / >> off-topic. > > This patch appears to reverse out the most recent committed changes in > copy.c. Which changes do you refer to? I thought I accommodated all the recent changes (I recall some changes to the tupleta

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-08-01 Thread Tom Lane
"Luke Lonergan" <[EMAIL PROTECTED]> writes: > On 7/29/05 5:37 AM, "Bruce Momjian" wrote: >> Where is the most recent version of the COPY patch? > I've attached it here, sorry to the list owner for the patch inclusion / > off-topic. This patch appears to reverse out the most recent committed chan

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-29 Thread Luke Lonergan
Bruce, On 7/29/05 5:37 AM, "Bruce Momjian" wrote: > Where is the most recent version of the COPY patch? My direct e-mails aren't getting to you, they are trapped in a spam filter on your end, so you didn't get my e-mail with the patch! I've attached it here, sorry to the list owner for the pat

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-29 Thread Bruce Momjian
Luke Lonergan wrote: > Mark, > > On 7/28/05 4:43 PM, "Mark Wong" <[EMAIL PROTECTED]> wrote: > > > Are there any recommendations for Qlogic controllers on Linux, scsi or > > fiber channel? I might be able to my hands on some. I have pci-x slots > > for AMD, Itanium, or POWER5 if the architecture

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-28 Thread Luke Lonergan
Mark, On 7/28/05 4:43 PM, "Mark Wong" <[EMAIL PROTECTED]> wrote: > Are there any recommendations for Qlogic controllers on Linux, scsi or > fiber channel? I might be able to my hands on some. I have pci-x slots > for AMD, Itanium, or POWER5 if the architecture makes a difference. I don't have

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-28 Thread Luke Lonergan
>>> Can you post the "time dd if=/dev/zero of=bigfile bs=8k count=50" >>> results? Also do the reverse (read the file) with "time dd if=bigfile >>> of=/dev/null bs=8k". > > I didn't see this come across before... here ya go: > > time dd if=/dev/zero of=bigfile bs=8k count=50 > > 50+

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-28 Thread Joshua D. Drake
[EMAIL PROTECTED] root]# /sbin/hdparm -tT /dev/sda /dev/sda: Timing buffer-cache reads: 1816 MB in 2.00 seconds = 908.00 MB/sec Timing buffered disk reads: 26 MB in 3.11 seconds = 8.36 MB/sec [EMAIL PROTECTED] root]# Can you post the "time dd if=/dev/zero of=bigfile bs=8k count=5000

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-28 Thread Mark Wong
On Fri, 22 Jul 2005 12:28:43 -0700 "Luke Lonergan" <[EMAIL PROTECTED]> wrote: > Joshua, > > On 7/22/05 10:11 AM, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > > The database server is a PE (Power Edge) 6600 > > > > Database Server IO: > > > > [EMAIL PROTECTED] root]# /sbin/hdparm -tT /dev/sda

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-23 Thread Luke Lonergan
Mark, On 7/22/05 12:47 PM, "Mark Wong" <[EMAIL PROTECTED]> wrote: > On a single spindle: > > $ time dd if=/dev/zero of=bigfile bs=8k count=200 > 200+0 records in > 200+0 records out > > real2m8.569s > user0m0.725s > sys 0m19.633s This is super fast! 124MB/s seems too f

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-23 Thread Luke Lonergan
Joshua, On 7/22/05 10:11 AM, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > The database server is a PE (Power Edge) 6600 > > Database Server IO: > > [EMAIL PROTECTED] root]# /sbin/hdparm -tT /dev/sda > > /dev/sda: > Timing buffer-cache reads: 1888 MB in 2.00 seconds = 944.00 MB/sec > Ti

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-22 Thread Mark Wong
On a single spindle: $ time dd if=/dev/zero of=bigfile bs=8k count=200 200+0 records in 200+0 records out real2m8.569s user0m0.725s sys 0m19.633s None of my drives are partitioned big enough for me to create 2x RAM sized files on a single disk. I have 16MB RAM and only 3

Re: [PERFORM] [PATCHES] COPY FROM performance improvements

2005-07-22 Thread Joshua D. Drake
Here is the SCSI output: Web Server SCSI subsystem driver Revision: 1.00 megaraid: v1.18j (Release Date: Mon Jul 7 14:39:55 EDT 2003) megaraid: found 0x1028:0x000f:idx 0:bus 4:slot 3:func 0 scsi0 : Found a MegaRAID controller at 0xf883f000, IRQ: 18 scsi0 : Enabling 64 bit support megaraid: [412