Re: [HACKERS] [Testperf-general] BufferSync and bgwriter

2004-12-12 Thread Mark Kirkwood
Simon, I am seeing a reasonably reproducible performance boost after applying your patch (I'm not sure if that was one of the main objectives, but it certainly is nice). I *was* seeing a noticeable decrease between 7.4.6 and 8.0.0RC1 running pgbench. However, after applying your patch, 8.0 is p

Re: [HACKERS] Status of server side Large Object support?

2004-12-12 Thread Bruce Momjian
Hannu Krosing wrote: > On E, 2004-11-29 at 02:22, David Garamond wrote: > > Joe Conway wrote: > > > Not if the column is storage type EXTERNAL. See a past discussion here: > > > http://archives.postgresql.org/pgsql-general/2003-07/msg01447.php > > > > what is the reasoning behind this syntax? > >

Re: [HACKERS] [Testperf-general] BufferSync and bgwriter

2004-12-12 Thread Neil Conway
On Sun, 2004-12-12 at 22:08 +, Simon Riggs wrote: > > On Sun, 2004-12-12 at 05:46, Neil Conway wrote: > > Is the plan to make bgwriter_percent = 100 the default setting? > > Hmm...must confess that my only plan is: > i) discover dynamic behaviour of bgwriter > ii) fix any bugs or wierdness as

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-12 Thread Bruce Momjian
Matthias Schmidt wrote: > > Am 07.12.2004 um 19:24 schrieb Tom Lane: > > > Matthias Schmidt <[EMAIL PROTECTED]> writes: > >> By the way: Do you have an idea about a small or > >> medium sized task from the TODO-List for a newbee, which gets me up to > >> speed?(!Win32) > > > > A lot of the tasks

Re: [HACKERS] old-style handler problem

2004-12-12 Thread Christopher Kings-Lynne
I think you have to use the PG_RETURN_DATUM(rc) style macros... Sibtay Abbas wrote: hi everyone i ve added my own pl language in postgresql. i ve followed the process mentioned in the documentation. for the handler function i ve followed the following template PG_FUNCTION_INFO_V1(myhandler); Datum

Re: [HACKERS] [Testperf-general] BufferSync and bgwriter

2004-12-12 Thread Simon Riggs
> On Sun, 2004-12-12 at 05:46, Neil Conway wrote: > Simon Riggs wrote: > > If the bgwriter_percent = 100, then we should actually do the sensible > > thing and prepare the list that we need, i.e. limit > > StrategyDirtyBufferList to finding at most bgwriter_maxpages. > > Is the plan to make bgwrit

Re: [HACKERS] buildfarm build failure: icc7 + --enable-cassert

2004-12-12 Thread Andrew Dunstan
Tom Lane said: > "Andrew Dunstan" <[EMAIL PROTECTED]> writes: >> Darcy Buskermolen wrote: It looks like --enable-cassert isn't handled properly under icc7 http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-07%2016:30:44> >> Maybe we need to look at some rpath settings? >

Re: [HACKERS] Anonymous CVS not updating?

2004-12-12 Thread Marc G. Fournier
thanks for the reminder ... fixed now, as are all of the other update scripts on that VM ... On Sun, 12 Dec 2004, Michael Fuhr wrote: Is there a problem with anonymous CVS? "cvs update" hasn't retrieved anything since before last week's outage. Or did I miss another message about CVS changes? %

Re: [HACKERS] buildfarm build failure: icc7 + --enable-cassert

2004-12-12 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > Darcy Buskermolen wrote: >>> It looks like --enable-cassert isn't handled properly under icc7 >>> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-07%2016:30:44 > Maybe we need to look at some rpath settings? Or PATH. If I'm read

Re: [HACKERS] Port report: Fedora Core 3 x86_64

2004-12-12 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > Instead of doing that, do: > --with-includes=/usr/include/et This same workaround is in the RPMs. I wonder if it would be worthwhile for configure to assume the above when --with-krb5 is mentioned. I don't know how widespread this particular file

Re: [HACKERS] buildfarm build failure: icc7 + --enable-cassert

2004-12-12 Thread Andrew Dunstan
Tom Lane said: > Peter Eisentraut <[EMAIL PROTECTED]> writes: >> Darcy Buskermolen wrote: >>> It looks like --enable-cassert isn't handled properly under icc7 >>> >>> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-07%2016:30:44> >> That is quite a superficial display of the is

Re: [HACKERS] buildfarm build failure: icc7 + --enable-cassert

2004-12-12 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Darcy Buskermolen wrote: >> It looks like --enable-cassert isn't handled properly under icc7 >> >> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=herring&dt=2004-12-07%2016:30:44 > That is quite a superficial display of the issue. If you want to

Re: [HACKERS] Call for port reports

2004-12-12 Thread Travis P
I tested with what dependencies were already available. Unfortunately, even --with-perl couldn't be used because the libraries are apparently non-shared (or so the build process reported). == AIX 5.1, 32-bit, four Power4 processors, # SELECT version(); Postgr

Re: [HACKERS] Port report: Fedora Core 3 x86_64

2004-12-12 Thread Andrew Dunstan
John Gray said: > All went mainly well - but a couple of gotchas on the build (these may > be Fedora bugs rather than PG ones). This install is pretty much brand > new (2 days old) with very little local configuration, so should > represent an FC3 out of the box. > > 1. com_err.h is in /usr/include

[HACKERS] Port report: Fedora Core 3 x86_64

2004-12-12 Thread John Gray
All went mainly well - but a couple of gotchas on the build (these may be Fedora bugs rather than PG ones). This install is pretty much brand new (2 days old) with very little local configuration, so should represent an FC3 out of the box. 1. com_err.h is in /usr/include/et/com_err.h and isn't fo

Re: [HACKERS] Anonymous CVS not updating?

2004-12-12 Thread Andrew Dunstan
Michael Fuhr said: > Is there a problem with anonymous CVS? "cvs update" hasn't retrieved > anything since before last week's outage. Or did I miss another > message about CVS changes? > > % cat CVS/Repository > pgsql > % cat CVS/Root > :pserver:[EMAIL PROTECTED]:/projects/cvsroot > Further dat

[HACKERS] Anonymous CVS not updating?

2004-12-12 Thread Michael Fuhr
Is there a problem with anonymous CVS? "cvs update" hasn't retrieved anything since before last week's outage. Or did I miss another message about CVS changes? % cat CVS/Repository pgsql % cat CVS/Root :pserver:[EMAIL PROTECTED]:/projects/cvsroot -- Michael Fuhr http://www.fuhr.org/~mfuhr/

Re: [Testperf-general] Re: [HACKERS] 8.0beta5 results w/ dbt2

2004-12-12 Thread Simon Riggs
On Sun, 2004-12-12 at 06:13, Tom Lane wrote: > Mark Wong <[EMAIL PROTECTED]> writes: > > I never vacuum during the test. Is it possible that all the updates > > and inserts would affect this? > > That's bad; first because it possibly *is* hurting performance, and > second because if it isn't, you