Re: [PATCHES] [PATCH] Compression and on-disk sorting

2006-05-18 Thread Simon Riggs
On Thu, 2006-05-18 at 10:31 +0200, Martijn van Oosterhout wrote: On Wed, May 17, 2006 at 06:38:47PM +0100, Simon Riggs wrote: - Each tape is compressed as one long compressed stream. Currently no seeking is allowed, so only sorts, no joins! (As tom said, quick and dirty numbers). This

Re: [PATCHES] [PATCH] Compression and on-disk sorting

2006-05-18 Thread Martijn van Oosterhout
On Thu, May 18, 2006 at 11:34:36AM +0100, Simon Riggs wrote: Just do a Z_FULL_FLUSH when you hit end of block. That way all blocks will be independent of each other and you can rewind as much as you like. We can choose the block size to be 32KB or even 64KB, there's no dependency there, just

Re: [PATCHES] [HACKERS] buildfarm failures

2006-05-18 Thread Bruce Momjian
Tom Lane wrote: Quite a few buildfarm members are failing with variants of Undefined symbol: _canonicalize_path in libpq. I think your recent patch that calls canonicalize_path from fe-connect.c is misguided in the first place; you certainly didn't ask for any discussion before applying it.

Re: [PATCHES] [PORTS] solaris build problem with Sun compilers

2006-05-18 Thread Bruce Momjian
Theo Schlossnagle wrote: On May 18, 2006, at 11:56 AM, Bruce Momjian wrote: Theo Schlossnagle wrote: On May 17, 2006, at 8:30 PM, Bruce Momjian wrote: [ snip ] OK, so what do you suggest? Remove that URL from the comments? Anything else? If you compile with -xarch=v8plus

Re: [PATCHES] [GENERAL] Querying libpq compile time options

2006-05-18 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: From: Bruce Momjian pgman@candle.pha.pa.us [EMAIL PROTECTED] wrote: Hi all I am writing an app that uses libpq, but because it is threaded I want to make sure that the dynamic library being used has been compiled with the right option. How do I do

Re: [PATCHES] [PATCH] Compression and on-disk sorting

2006-05-18 Thread Jim C. Nasby
On Thu, May 18, 2006 at 10:31:03AM +0200, Martijn van Oosterhout wrote: Besides, we still havn't got any reports yet that this actually provides a benefit on any machine less than five years ago. Anyone out there doing tests? Yes. I'm compiling the patched binaries right now, but the baseline