Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance tweak

> "Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Hm, what were the tests exactly?  Offhand I'd expect something like a
> SELECT COUNT(*) on a large but not-too-wide table to show noticeable
> improvement.
>
>             regards, tom lane
I STAND CORRECTED!  My tests were high volume record by record
iterators, etc.  Read and drool, gentlemen.

Merlin

=============stock============

esp=# select count(*) from data1.line_file;count
--------321306
(1 row)

Time: 844.000 ms
esp=# select count(*) from data1.line_file;count
--------321306
(1 row)

Time: 843.000 ms
esp=# select count(*) from data1.line_file;count
--------321306
(1 row)

Time: 844.000 ms
esp=# \q
=============patched============
esp=# \timing
Timing is on.
esp=# select count(*) from data1.line_file;count
--------321306
(1 row)

Time: 453.000 ms
esp=# select count(*) from data1.line_file;count
--------321306
(1 row)

Time: 468.000 ms
esp=# select count(*) from data1.line_file;count
--------321306
(1 row)

Time: 469.000 ms