Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes: > Thanks. Now, we have some more warnings/errors: > http://www.gunduz.org/postgresql/postgres-A4.log.gz You need bigger TeX settings. Please read "Building the Documentation". regards, tom lane --

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Devrim GÜNDÜZ
Hi, On Mon, 2007-12-03 at 18:51 -0500, Tom Lane wrote: > Those are the same version numbers I see in Fedora 6, which doesn't > behave like that ... Anyway, I've committed some cleanup in HEAD. Thanks. Now, we have some more warnings/errors: http://www.gunduz.org/postgresql/postgres-A4.log.gz

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hmph. What version of the SGML tools are you using? It seems more >> prone to get confused by non-entity-ized '<' and '>' than what the >> rest of us are using. > I'm not totally au fait with the rules of SGML. Does it allow literal

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes: > On Mon, 2007-12-03 at 17:49 -0500, Tom Lane wrote: >> Hmph. What version of the SGML tools are you using? > The ones supplied with Fedora 8. > sgml-common: 0.6.3 > openjada: 1.3.2 Those are the same version numbers I see in Fedo

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Andrew Dunstan
Tom Lane wrote: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes: I got some SGML errors: https://devrim.privatepaste.com/501oMnwCYw Hmph. What version of the SGML tools are you using? It seems more prone to get confused by non-entity-ized '<' and '>' than what the res

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Devrim GÜNDÜZ
Hi, On Mon, 2007-12-03 at 17:49 -0500, Tom Lane wrote: > > I got some SGML errors: > > https://devrim.privatepaste.com/501oMnwCYw > > Hmph. What version of the SGML tools are you using? The ones supplied with Fedora 8. sgml-common: 0.6.3 openjada: 1.3.2 Regards, -- Devrim GÜNDÜZ , RHCE Pos

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Jeff Davis
On Mon, 2007-12-03 at 20:40 +, Gregory Stark wrote: > I'm not sure where the idea of keeping the current bounds of the input tapes > comes into it. We only preread when we run out of tuples anyways and then we > don't really have a choice about which tape we want to preread from. And it's > a g

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes: > I got some SGML errors: > https://devrim.privatepaste.com/501oMnwCYw Hmph. What version of the SGML tools are you using? It seems more prone to get confused by non-entity-ized '<' and '>' than what the rest of us are using.

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Devrim GÜNDÜZ
Hi, On Mon, 2007-12-03 at 18:33 -0300, Alvaro Herrera wrote: > No, the reason for that error message is that it is trying to generate > postgres.pdf from postgres.gif. Try "make postgres-A4.pdf" or > postgres-US.pdf instead. Oh, thanks :) I got some SGML errors: https://devrim.privatepaste.com

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Jeff Davis
On Mon, 2007-12-03 at 20:40 +, Gregory Stark wrote: > So the question is just how many seeks are we doing during sorting. If we're > doing 0.1% seeks and 99.9% sequential i/o then eliminating the 1% entirely > (which we can't do) isn't going to speed up seeking all that much. If we're > doing 2

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Gregory Stark
"Simon Riggs" <[EMAIL PROTECTED]> writes: > The buffer size at max tapes is an optimum - a trade off between > avoiding intermediate merging and merging efficiently. Freeing more > memory is definitely going to help in the case of low work_mem and lots > of runs. I can't follow these abstract arg

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Alvaro Herrera
Devrim GÜNDÜZ wrote: > Hi, > > I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this > error: > > cp ./../graphics/postgres.gif . > cp: cannot stat `./../graphics/postgres.gif': No such file or directory > make: *** [postgres.gif] Error 1 No, the reason for that error message is t

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Simon Riggs
On Mon, 2007-12-03 at 20:40 +, Gregory Stark wrote: > I think the way to do what you're proposing is... Don't understand that. Algorithm F covers that already doesn't it? > So the question is just how many seeks are we doing during sorting. If we're > doing 0.1% seeks and 99.9% sequential i/

Re: [HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Kris Jurka
On Mon, 3 Dec 2007, Devrim G?ND?Z wrote: I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this error: You need to say "make postgres-US.pdf" or -A4. The .gif file is coming from make's default rules. Perhaps we should provide a real target matching postgres.pdf and error

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Gregory Stark
"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Mon, 2007-12-03 at 10:32 -0800, Jeff Davis wrote: > >> If I understand correctly, we just keep track of the maximum value of >> the last block read from each run, and then always read from the run in >> which the last block read has the lowest maximu

[HACKERS] Is postgres.gif missing in cvs?

2007-12-03 Thread Devrim GÜNDÜZ
Hi, I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this error: cp ./../graphics/postgres.gif . cp: cannot stat `./../graphics/postgres.gif': No such file or directory make: *** [postgres.gif] Error 1 CVS/tarball does not include this file, and I think we should add. Regards, --

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Simon Riggs
On Mon, 2007-12-03 at 10:32 -0800, Jeff Davis wrote: > If I understand correctly, we just keep track of the maximum value of > the last block read from each run, and then always read from the run in > which the last block read has the lowest maximum. Yep, sounds like Algorithm F > It seems as if

Re: [HACKERS] buildenv.pl/buildenv.bat

2007-12-03 Thread Magnus Hagander
On Mon, 2007-12-03 at 12:15 -0500, Andrew Dunstan wrote: > > Magnus Hagander wrote: > > Hi! > > > > When you redid the msvc build stuff you seem to have missed the > > documentatino.. Specifically, I notice that buildenv.pl isn't documented - > > docs still say buildenv.bat is the way to go. > >

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Jeff Davis
On Mon, 2007-12-03 at 11:51 +, Simon Riggs wrote: > So Algorithm F is somewhat orthogonal to what I've proposed, though > maybe still interesting. What we do now is fairly close, but you should > look at the code in tuplesort.c and logtape.c to see how well it > matches. That might lead to an i

[HACKERS] Kludge in pg_standby.c

2007-12-03 Thread Gregory Stark
There's a suspicious ifdef in pg_standby for WIN32 which smells like a kludge added to work around a Windows problem which makes it work but at great expense: #ifdef WIN32 /* * Windows reports that the file has the right number of bytes * even tho

Re: [HACKERS] 8.3 beta 4 crash on windows 2003 64-bit

2007-12-03 Thread Filip Wuytack
Andrew, As to how it was built: I was under the impression that the 8.3 release is build using MSVSC? I was keen to give it a try to see if this version would work more optimally on windows as the pg instance (8.2.5) I run normally suffers from serious high pages/sec (by looking at perfmon on wi

Re: [HACKERS] buildenv.pl/buildenv.bat

2007-12-03 Thread Andrew Dunstan
Magnus Hagander wrote: Hi! When you redid the msvc build stuff you seem to have missed the documentatino.. Specifically, I notice that buildenv.pl isn't documented - docs still say buildenv.bat is the way to go. Also, do we now have both buildenv.bat and buildenv.pl? (I have them both in my e

Re: [HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Magnus Hagander
Magnus Hagander wrote: > Andrew Dunstan wrote: >> >> Magnus Hagander wrote: >>> Did we ever come to a conclusion on what to do with integer datetimes on >>> msvc for 8.3? >>> >>> For the uninformed - 8.2 and earlier had the binary build with floating >>> point timestamps, 8.3 has integer timestamps

Re: [HACKERS] 8.3 beta 4 crash on windows 2003 64-bit

2007-12-03 Thread Filip Wuytack
From the postgresql ftp server. I initially wanted to download beta3, but spotted beta4 so I gave that a go ftp.postgresql.org /pub/binary/v8.3beta4/win32/ ~ Filip -Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Sent: 03 December 2007 17:09 To: Filip Wuytack Cc: pgsq

Re: [HACKERS] 8.3 beta 4 crash on windows 2003 64-bit

2007-12-03 Thread Andrew Dunstan
Filip Wuytack wrote: Hi, I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to restore a database into it (about 30GB,5schemas and about 2000 tables) but whenever I try to open the tables in pgadmin3, the database crashes (i've tried with both the default postgresql.conf file an

Re: [HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Magnus Hagander
Andrew Dunstan wrote: > > > Magnus Hagander wrote: >> Did we ever come to a conclusion on what to do with integer datetimes on >> msvc for 8.3? >> >> For the uninformed - 8.2 and earlier had the binary build with floating >> point timestamps, 8.3 has integer timestamps. (We're just talking the >>

Re: [HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Michael Glaesemann
On Dec 3, 2007, at 11:27 , Tom Lane wrote: I believe we have consensus that 8.4 is the time to do that --- see thread here: http://archives.postgresql.org/pgsql-patches/2007-05/msg00046.php Is there anything in the release notes (or elsewhere) for 8.3 that mention this as the intention, si

Re: [HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Andrew Dunstan
Magnus Hagander wrote: Did we ever come to a conclusion on what to do with integer datetimes on msvc for 8.3? For the uninformed - 8.2 and earlier had the binary build with floating point timestamps, 8.3 has integer timestamps. (We're just talking the binary build here) If you are prepa

[HACKERS] 8.3 beta 4 crash on windows 2003 64-bit

2007-12-03 Thread Filip Wuytack
Hi, I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to restore a database into it (about 30GB,5schemas and about 2000 tables) but whenever I try to open the tables in pgadmin3, the database crashes (i've tried with both the default postgresql.conf file and with some more tuned on

Re: [HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Did we ever come to a conclusion on what to do with integer datetimes on > msvc for 8.3? > For the uninformed - 8.2 and earlier had the binary build with floating > point timestamps, 8.3 has integer timestamps. (We're just talking the > binary build he

Re: [HACKERS] buildenv.pl/buildenv.bat

2007-12-03 Thread Magnus Hagander
On Mon, Dec 03, 2007 at 10:52:15AM -0500, Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > When you redid the msvc build stuff you seem to have missed the > > documentatino.. Specifically, I notice that buildenv.pl isn't documented - > > docs still say buildenv.bat is the way to go

[HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Magnus Hagander
Did we ever come to a conclusion on what to do with integer datetimes on msvc for 8.3? For the uninformed - 8.2 and earlier had the binary build with floating point timestamps, 8.3 has integer timestamps. (We're just talking the binary build here) //Magnus ---(end of broa

Re: [HACKERS] buildenv.pl/buildenv.bat

2007-12-03 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > When you redid the msvc build stuff you seem to have missed the > documentatino.. Specifically, I notice that buildenv.pl isn't documented - > docs still say buildenv.bat is the way to go. On a related note, I was wondering yesterday if there are any o

Re: [GENERAL] [HACKERS] Stored procedure issue

2007-12-03 Thread Pavel Stehule
Hello On 03/12/2007, Dragan Zubac <[EMAIL PROTECTED]> wrote: > Hello > > What I have noticed is that when I don't use procedure > at all,there's only 2-5 locks in pg_locks,after I > start application which uses stored procedure the > number in pg_locks increase rapidly to steady 75 even > to 130 a

Re: [HACKERS] Regression testing

2007-12-03 Thread Alvaro Herrera
cinu wrote: > GNUmakefile:15: ../../../src/Makefile.global: No such > file or directory > GNUmakefile:78: /src/Makefile.shlib: No such file or > directory > gmake: *** No rule to make target > `/src/Makefile.shlib'. Stop. You need to run "configure" first (found in the top-level directory), so t

Re: [HACKERS] Stored procedure issue

2007-12-03 Thread Dragan Zubac
Hello What I have noticed is that when I don't use procedure at all,there's only 2-5 locks in pg_locks,after I start application which uses stored procedure the number in pg_locks increase rapidly to steady 75 even to 130 at certain moments. Any clue why procedure usage might increase locks so he

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-03 Thread Simon Riggs
On Fri, 2007-11-30 at 12:07 -0800, Jeff Davis wrote: > On Tue, 2007-11-27 at 18:03 +, Simon Riggs wrote: > > 5. DYNAMIC RUN HANDLING (in Final Merge) > > > > Another way of addressing a) is to simply make better use of memory > > itself. Let's look at that in more detail: > > > > Number of r

[HACKERS] Regression testing

2007-12-03 Thread cinu
Hi All, I am trying to do a regression testing on the version installed. Now on the installed version of postgreSQL-8.2.4 with the service started, and at the regress filder, I run the command "gmake installcheck", when I run this command I get the following message: GNUmakefile:15: ../../../

Re: [HACKERS] buildenv.pl/buildenv.bat

2007-12-03 Thread Dave Page
Magnus Hagander wrote: > Hi! > > When you redid the msvc build stuff you seem to have missed the > documentatino.. Specifically, I notice that buildenv.pl isn't documented - > docs still say buildenv.bat is the way to go. > > Also, do we now have both buildenv.bat and buildenv.pl? (I have them bo

[HACKERS] buildenv.pl/buildenv.bat

2007-12-03 Thread Magnus Hagander
Hi! When you redid the msvc build stuff you seem to have missed the documentatino.. Specifically, I notice that buildenv.pl isn't documented - docs still say buildenv.bat is the way to go. Also, do we now have both buildenv.bat and buildenv.pl? (I have them both in my environment, but that could

Re: [HACKERS] .NET or Mono functions in PG

2007-12-03 Thread James Mansion
Tom Lane wrote: It is also pretty well established that if pltcl or plperl cause the backend to become multithreaded, things break horribly. I strongly Isn't that something that needs to be fixed? Its one thing not to allow for multiple threads to be in your code, but not having a threaded