Re: [HACKERS] [PATCHES] Avahi support for Postgresql

2008-02-23 Thread Mathias Hasselmann
Hello, Congratulations to the 8.3 release. No, that pre-release stress is over I'd really like to put attention on my Avahi patches again. Avahi/Bonjour/DNS-SD support[1] is very important, for integrating Postgresql with modern desktop environments like OSX, GNOME, KDE: It's very convenient to c

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
Stefan Kaltenbrunner wrote: Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Yeah, that... is beyond my abilities. Well reading it is anyway. I can provide any information people want though. Tom? Greg? Andrew? Somebody? What information do you want from me to help you track this d

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Stefan Kaltenbrunner
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Yeah, that... is beyond my abilities. Well reading it is anyway. I can provide any information people want though. Tom? Greg? Andrew? Somebody? What information do you want from me to help you track this down? The vmstat output you

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Tom Lane
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> The vmstat output you showed before said user CPU time was only around >> 12%, which seems to destroy Luke's thesis that data conversion time >> is the problem. > Joshua said this is an 8 core box - so 12% would about equal to o

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
Tom Lane wrote: Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: Tom Lane wrote: The vmstat output you showed before said user CPU time was only around 12%, which seems to destroy Luke's thesis that data conversion time is the problem. Joshua said this is an 8 core box - so 12% would about eq

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Oh, good point. That should be fairly easy to confirm with "top" I >> would think. > mpstat -P ALL 5 > 01:43:38 PM CPU %user %nice%sys %iowait%irq %soft %steal >%idleintr/s > 01:43:43 PM all 13.100

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Tom Lane wrote: Oh, good point. That should be fairly easy to confirm with "top" I would think. mpstat -P ALL 5 01:43:38 PM CPU %user %nice%sys %iowait%irq %soft %steal %idleintr/s 01:43:43 PM all 13.

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
Joshua D. Drake wrote: OK, so it is CPU-bound after all. Do you have oprofile or anything equivalent? I am at your disposal. If you need oprofile tell me the command and I will get you the output. (thanks to stefan for helping me get this output) opreport -l /usr/bin/postgres CPU: AMD64 p

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > opreport -l /usr/bin/postgres > CPU: AMD64 processors, speed 2411.14 MHz (estimated) > Counted CPU_CLK_UNHALTED events (Cycles outside of halt state) with a > unit mask of 0x00 (No unit mask) count 10 > samples %symbol name > 4765415

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: opreport -l /usr/bin/postgres CPU: AMD64 processors, speed 2411.14 MHz (estimated) Counted CPU_CLK_UNHALTED events (Cycles outside of halt state) with a unit mask of 0x00 (No unit mask) count 10 samples %symbol name 476

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: opreport -l /usr/bin/postgres CPU: AMD64 processors, speed 2411.14 MHz (estimated) Counted CPU_CLK_UNHALTED events (Cycles outside of halt state) with a unit mask of 0x00 (No unit mask) count 10 samples %symbol name 476

Re: [HACKERS] [PATCHES] Avahi support for Postgresql

2008-02-23 Thread Peter Eisentraut
Mathias Hasselmann wrote: > Congratulations to the 8.3 release. No, that pre-release stress is over > I'd really like to put attention on my Avahi patches again. I've added your item to the patch list (http://developer.postgresql.org/index.php/Todo:PatchStatus). It would help if you could inclu

Re: [HACKERS] [PATCHES] Avahi support for Postgresql

2008-02-23 Thread Mathias Hasselmann
Am Samstag, den 23.02.2008, 21:08 +0100 schrieb Peter Eisentraut: > Mathias Hasselmann wrote: > > Congratulations to the 8.3 release. Now, that pre-release stress is over > > I'd really like to put attention on my Avahi patches again. > > I've added your item to the patch list > (http://develope

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Heikki Linnakangas
Joshua D. Drake wrote: Joshua D. Drake wrote: OK, so it is CPU-bound after all. Do you have oprofile or anything equivalent? I am at your disposal. If you need oprofile tell me the command and I will get you the output. (thanks to stefan for helping me get this output) opreport -l /usr/b

Re: [HACKERS] 8.3 / 8.2.6 restore comparison

2008-02-23 Thread Joshua D. Drake
On Sun, 24 Feb 2008 00:43:18 + "Heikki Linnakangas" <[EMAIL PROTECTED]> wrote: > Incidentally, I've been working on a patch to speed up CopyReadLine. > I was going to run some more tests first, but since we're talking > about it, I guess I should just post the patch. I'll post to > pgsql-patc