-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> this looks superb.
>
> one small question though; how do i apply the patch ?
I'll assume you have the sources for 7.1.3. I'll rewrite the
patch for 7.2b3 in a little bit.
Change to the top level of the postgresql source tree.
> cd postgresql-7.1.3
Save the file at
http://www.gtsm.com/postgres/microtiming.patch
to a local file, perhaps named "microtiming.patch"
> wget http://www.gtsm.com/postgres/microtiming.patch
Patch the source with the file:
> patch -bp0 < microtiming.patch
If all goes well, you should see:
patching file ./src/bin/psql/command.c
patching file ./src/bin/psql/common.c
patching file ./src/bin/psql/help.c
patching file ./src/bin/psql/print.h
patching file ./src/bin/psql/startup.c
patching file ./src/bin/psql/tab-complete.c
patching file ./doc/src/sgml/ref/psql-ref.sgml
You can then run make from the top-level directory, or
to avoid some output, cd to src/bin/psql and run
make from there:
>cd src/bin/psql; make
When finished, you'll have a new psql binary in the
src/bin/psql directory, which should have the microtiming
stuff. Test it out before copying it over to anywhere
permanent:
>./psql
template1=# select version();
version
- - --------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 3.0.1
(1 row)
template1=# \m
Microsecond timing is on.
template1=# select version();
version
- - --------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 3.0.1
(1 row)
TOTAL TIME: 0.001660
template1=#
Greg Sabino Mullane
greg@turnstep.com
PGP Key: 0x14964AC8 200111281041
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iQA/AwUBPAUIGrybkGcUlkrIEQK8BACcCpmnGT0u99QE+lLxhAyujiEDExgAoJ1C
8GpR/1FBwfHvO0u0P0G7tK2d
=JqYc
-----END PGP SIGNATURE-----