Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance
Date
Msg-id 435A7DC6.9070606@dunslane.net
Whole thread Raw
In response to Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance
List pgsql-hackers

Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.net> writes:
>  
>
>>I could make the whole dataset available, but tarred and zipped it's 
>>about 300Mb. The reason I used this dataset was that I wanted to see a 
>>test that took many seconds, and Merlin's did not - I wanted to see how 
>>any performance gain scaled.
>>    
>>
>
>Well, you tried to "scale" into a domain where the performance is going
>to be disk-I/O-limited, so I'm not sure it proves anything.
>
>
>  
>

Good point. I took a 5% random extract from the lineitems table and saw 
the expected improvement.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance