Re: [HACKERS] spi and other languages
On Mon, Dec 06, 2004 at 11:05:28PM -0800, Sibtay Abbas wrote: i guess the answer to my previous question was spi...i ve got another question, can we call pgsql or plpgsql functions using spi? like can we do something like SPI_execute(CREATE FUNCTION blah() RETURNS Integer . What happened when you tried it? Are you trying to call a function or create one? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] apparent problem on linux/s390
Hello, On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan [EMAIL PROTECTED] wrote: problems apparently with NaNs, infinities and negative zeros. I am the owner of this baby. It is not an actual mainframe, it is Hercules emulator running on AthlonXP 2500+ producing 20-25 MIPS of pure mainframe horsepower! On bootup Linux reports 130 BogoMIPS and OS/390 reports 40 MIPS. We all know that mainframe MIPS != mini MIPS. Anyways, a full compile of PostgreSQL source takes about 300 minutes. I run it overnight. Hercules is a tested and proved emulator but I have a vague doubt that it's IEEE FPU emulation may be slightly different from the real iron's one. Are there test suites to check if a linux's math functions confirm to the standards. I may need to run one of them first. Also if the is something to do with the code I am more than willing to help. Seems like nobody else has a mainframe handy for testing. I will do what I can but bear in mind the compile time. In case anyone wants to try it at home I will help to set it up, it is really easy once it is up and running it is the same old Linux to you. As for urgency of bugfixes for S390 platform I am not aware of anyone running PostgreSQL on IFL (integrated facility for Linux). And I am not aware of anyone who would even consider this. Mainframe users are all so scared by IBM FUD. Nevertheless running PostgreSQL in iron is an important sales pitch for me and Devrim. Imagine: Of course it runs on mainframe or Save $2,573,000.00 in monthly software licence fees, use PostgreSQL!. see: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=fantaildt=2004-12-06%2011:05:24 Meanwhile another fresh build completed with absolutely the same result: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=fantaildt=2004-12-06%2023:04:43 Best regards, Nicolai Tufar ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [Testperf-general] Re: [HACKERS] 8.0beta5 results w/ dbt2
On Mon, 2004-12-06 at 23:54, Mark Wong wrote: On Mon, Dec 06, 2004 at 11:44:22PM +, Simon Riggs wrote: On the graphs... why do the graphs for Proc Utilisation, Index Scans etc, only show first 300 secs of a 3600 sec long run? Are those axes correct? (I understand seeing the ramp-up is important, I just want to check the time axis). What do you think the periodicity is on those graphs that has an order of around 10 secs if that axis is correct? Thats about every 400 transactions. Anybody? Whoops! Those are supposed to be minutes. The granularity of the intervals have always been 1 minute (60 seconds). I wonder why I put seconds on the charts... I'll fix that too. OK...at least the results are starting to be coherent now... All the graphs now show we have 3 main states: 1. normal running 2. a periodicity of about 7 per 5 mins: ~42 secs 3. a periodicity of about 5 mins 1 gives good performance, most transactions 2 sec 2 gives mild performance reductions, blocking transactions for ~7 secs 3 gives bad performance reductions, blocking transactions for ~12 secs We think effect 3 is a checkpoint... Not sure, as yet, what is causing effect 2. It's not related to the kernel, but is related to user CPU and I/O waits and effects all tables in proportion to their overall I/O usage. Some evidence that it becomes more pronounced as CPU utilisation peaks, possibly increasing slightly in frequency once this occurs: maybe the cache filling? Conjecture: effect 2 is caused by insufficient bgwriter activity. The bgwriter writes less dirty blocks than are being written by users, so the cache slowly fills with dirty blocks. Then user processes must write their own dirty blocks to disk before we continue. [Not sure about this, but conjecture at least covers: wierd periodicity, I/O effect, cache full effect and the lack of impact of bgwriter parameter changes] -- Best Regards, Simon Riggs ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] V8 Beta 5 on AIX
OK, so does someone want to suggest why a library used to link libpq would also be needed to link binaries that use libpq? And with no cc_r it seems I have no idea how to get this working. AIX does not pull in any libraries that a shared lib depends upon, not even libc. You only specify those on the .so link line so the linker can check what is unresolved. If he does not have cc_r, then he eighter uses gcc or a newer compiler, that does not need cc_r any more ??? I would generally use cc_r if it exists or gcc for the threaded build. The performance difference between cc and cc_r should not be noticeable. Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] How can I recovery old Data from files and folders on windows?
I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of it back it will be make a same error. I just want to restore only DATA (databases, functions, views, users, group etc). Please suggest me that How can I recovery old Data from files and folders on windows? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] spi and other languages
i am still in my RD phase so i ve not yet tried it. actually i chose the wrong example. We can call SQL statements like SPI_Execute(SELECT * FROM sometable) from the spi interface. My question is that can we enter other procedural languages as well, like pgplsql statements. __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Eisentraut Sent: 07 December 2004 00:01 To: [EMAIL PROTECTED] Subject: [HACKERS] Call for port reports I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check All tests passed on Win32 (including a make installcheck in /contrib). *However*, note that PAM, Kerberos and pthreads do not (yet) work on Windows and were therefore excluded. SELECT version(): PostgreSQL 8.0.0rc1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.3.1 (mingw special 20030804-1) uname -a: MINGW32_NT-5.1 PC30 1.0.10(0.46/3/2) 2004-03-15 07:17 i686 unknown Regards, Dave ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
smallmouth:~/tmp ronz$ uname -a Darwin smallmouth.local 7.5.0 Darwin Kernel Version 7.5.0: Thu Aug 5 19:26:16 PDT 2004; root:xnu/xnu-517.7.21.obj~3/RELEASE_PPC Power Macintosh powerpc (or OS X 10.3.5) ./configure --prefix=/Users/ronz/tmp/pgsql8 --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-pam -with-openssl --with-libs=/sw/lib --with-includes=/sw/include all 96 tests passed [local]:template1=# select version(); version PostgreSQL 8.0.0rc1 on powerpc-apple-darwin7.5.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495) Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] apparent problem on linux/s390
Nicolai Tufar said: Hello, On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan [EMAIL PROTECTED] wrote: problems apparently with NaNs, infinities and negative zeros. I am the owner of this baby. It is not an actual mainframe, it is Hercules emulator running on AthlonXP 2500+ producing 20-25 MIPS of pure mainframe horsepower! On bootup Linux reports 130 BogoMIPS and OS/390 reports 40 MIPS. ... Hercules is a tested and proved emulator but I have a vague doubt that it's IEEE FPU emulation may be slightly different from the real iron's one. Maybe we should mark the buildfarm member as s390 emulator ? Meanwhile, if anyone knows of real big iron that could join the buildfarm that would also be good. cheers andrew ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] apparent problem on linux/s390
On Tue, 7 Dec 2004 06:38:25 -0600 (CST), Andrew Dunstan [EMAIL PROTECTED] wrote: Maybe we should mark the buildfarm member as s390 emulator ? It could be. But we'd rather use the full specification, Hercules 2.37, ESAME S390 architecture, 31 bit mode, running Debian Linux Woody or something like that. Don't quote it now though, I do not remember what was the version Hercules I used. But in my opinion what runs on Hercules runs on Mainframe too, we can safely claim that we compiled and tested on a mainframe. Meanwhile, if anyone knows of real big iron that could join the buildfarm that would also be good. It will be great. There should be some universities that still use mainframe and some of them even installed Linux. Compiling PostgreSQL is extremely resource hungry process. I doubt a business will lend its mainframe for such a purpose. Also the used to be P390 - personal mainframes machines produced by IBM a decade ago. They still can be bought on eBay for something like $5,000. They can run Linux too. Regards, Nicolai Tufar ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] V8 Beta 5 on AIX
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: However, one thing we can do is to try this in Makefile.aix: # AIX needs threads for everything that uses libpq LIBS += $(PTHREAD_LIBS) That is going to enable thread libs for all linking including the backend, but it might work. That is certainly wrong. The correct thing is to add PTHREAD_LIBS to all and only those links that include libpq. I suspect that the cc_r business is a red herring and the real problem is just that you forgot to include the libraries --- if so, AIX is probably not the only platform that will break. The discussion at the time was that we didn't want to add a libpq-specific CC just for Unixware, which we considered broken for not having libpq dependency information in the library. Now that we have two platforms that need this we might need to rethink this, and think of a shortcut for 8.0 like we are already using for Unixware. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] adding procedural languages
hi everyone ok i ve tried to add my own procedural language using the call handler interface. I am doining nothing in the handler function except tyring to print a mess through errmsg function (plz correct me if i am wrong here, since i cant see the message which i am printing) Now my question is that how can i explicitly specify that i want my pl language to be used. I think i have added my language successfully by following the procedure mentioned in the documentation. So now how do i inform the database engine to use my language for a specific query thank you __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] V8 Beta 5 on AIX
On Mon, Dec 06, 2004 at 10:17:53PM +, Simon Riggs wrote: To the extent AIX is popular :) 5.1 is one release behind the very latest. AIX 5.3 is out now... AIX 5.1 is still fully supported though... Oops, sorry, I meant one behind the very latest supported by our provider. For reasons I don't quite understand, IBM's own hosting facilities seem to lag on the AIX releases. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] apparent problem on linux/s390
Andrew Dunstan [EMAIL PROTECTED] writes: Hercules is a tested and proved emulator but I have a vague doubt that it's IEEE FPU emulation may be slightly different from the real iron's one. Maybe we should mark the buildfarm member as s390 emulator ? Meanwhile, if anyone knows of real big iron that could join the buildfarm that would also be good. I can't put it in the buildfarm ;-) but I have access to real s390 hardware inside Red Hat. I'll try to run a test build and see whether the regression tests pass. I would expect that s390 floating point is not even remotely IEEE-compliant; they'd have stuck with the S/360 behavior which predates the IEEE spec by probably 20 years. Whether it's worth generating variant regression files for this arch, I don't know. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] adding procedural languages
Sibtay Abbas wrote: hi everyone ok i ve tried to add my own procedural language using the call handler interface. I am doining nothing in the handler function except tyring to print a mess through errmsg function (plz correct me if i am wrong here, since i cant see the message which i am printing) Now my question is that how can i explicitly specify that i want my pl language to be used. I think i have added my language successfully by following the procedure mentioned in the documentation. So now how do i inform the database engine to use my language for a specific query Is this part of an academic project or something? Frankly, it looks to me like you need to acquire a lot of basic knowledge about how postgresql works internally before you even start thinking about what you are trying to do. Serverside PLs can only be used in user-defined functions, and the language used is specified in the function definition, as in create function foo() returns text language mypl as $$ code in mypl $$; cheers andrew ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] How can I recovery old Data from files and folders
Premsun Choltanwanich wrote: I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of it back it will be make a same error. I just want to restore only DATA (databases, functions, views, users, group etc). Please suggest me that How can I recovery old Data from files and folders on windows? PostgreSQL does not work like that. You should have backed up using pg_dump before uninstalling. File system backup won't work across catalog versions. In fact, your best bet is probably to reinstall the old version so you can start the server and run pg_dump. cheers andrew ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Call for port reports
Title: RE: [HACKERS] Call for port reports Port report for Gentoo (www.gentoo.org) Linux: No errors. uname -a: Linux imgvmhost 2.4.26-gentoo-r3 #1 Tue Sep 7 14:20:02 EDT 2004 i686 Intel(R) Pentium(R) 4 CPU 2.40GHz GenuineIntel GNU/Linux gcc -v: gcc version 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) configure: ./configure --prefix=$mypg --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-pam -with-openssl make check: == All 96 tests passed. == version: template1=# select version(); version PostgreSQL 8.0.0rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) (If there are other combinations of options anyone would like me to try, just let me know. I don't know which combinations are interesting, since the defaults work for my application.)
Re: [HACKERS] how can i add my own procedural language?
Thomas Hallgren [EMAIL PROTECTED] writes: Sibtay, You normally don't deal with parsing, planning etc. at all from within a language handler. Unless you're implementing a language from scratch rather than linking in an existing interpreter. In which case, the PL/pgSQL source is a good example. -Doug ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]