Re: [HACKERS] Postgres-R source code release
On 15/07/2008, David E. Wheeler [EMAIL PROTECTED] wrote: Of course, I am personally happy with SVN but hey :P You can't have tried a merge in SVN if that's so :P :P Those of us who have been doing it for years, in CVS and in SVN, aren't too worried about it. Follow the sandal! :D -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] [0/4] Proposal of SE-PostgreSQL patches
On 01/05/2008, Josh Berkus [EMAIL PROTECTED] wrote: Further, I've asked the TrustedSolaris folks to take a look at KaiGai's implementation to see if it was generic enough for them to build on as a test of whether SE-Postgres was too specific to SE-Linux; the answer has been a tentative yes, it's generic. So it would be much better to have this functionality be mainstream rather than a fork. If it does get bounced, please do it becuase of code quality and not because nobody is asking for this. Not a hacker, just a curious reader ... are there equivalent frameworks for the other supported platforms? E.g. MacOS, *BSD, Windows? Are the similarities between those (if they exist) close enough not to introduce a maintenance nightmare? Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Two Coverity Scan volunteers needed
On 27/02/2008, Neil Conway [EMAIL PROTECTED] wrote: I think you need human verification / analysis, which isn't an easy thing to script. Is that site publicly accessible, do they have some sample output that one could examine in regards to Joshua's parsing idea? -Neil Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Wrote a connect-by feature
On 8/14/07, Bertram Scharpf [EMAIL PROTECTED] wrote: I just forgot to refer to--of course--the German knight of the iron hand. Prima donna? Not quite done yet? Denk mal nach. Kritik kann wohl begruendet sein. Und was die Jungs gesagt haben war sowohl inhaltlich als auch von Votrag her vollkommen angemessen. Oh well. Pity. I thought it was an interesting contribution. Bertram Cheers, Andrej ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] one click install?
On 6/13/07, Andrew Hammond [EMAIL PROTECTED] wrote: The problem here is that there aren't really very many defined defaults, or that these defaults vary (sometimes greatly) between the different flavors of UNIX. For example, please tell me: 1) Where should PGDATA default to? 2) How do you want to handle logging output from the postmaster? There are plenty of options... 3) Where should those log files get written? 4) For 1 and 3, will that support multiple major versions of PostgreSQL? (ie, can I have 8.2.latest and 8.1.latest installed at the same time) 5) How about multiple postmasters (on different ports)? Exactly :} ... all very good points... and then there's still the ownerships of processes and directories/files, and their perms. And integration with the init-scripts. And how e.g. the environment variables for users should be handled. I think that the community would be well served by standardizing on these things, at least for basic installations. But whose decision should that be? The postgres' developers? I think that the defaults that the configure script suggests are quite sane, and happily use them in my Slackware installations. Linux File system Hierarchy standards? Which major distro(s)? And what about the BSDs (or the commercial Unices supported)? And while at it: who would define what a basic installation is? :) -- Cheers, Andrej ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server
On 5/23/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote: As an amusing side note, I have heard a claim that the only reason we need endianity at all is because the Europeans didn't understand that Arabic is written from right to left. In Arabic you read 17 as seven and ten, which means that it is already little endian. Just one request, please don't quote this story without also mentioning that this story is wrong, and that 1234 is said, in Arabic, as one thousand two hundred four and thirty. For the record, dutch works like too, Same for German and Slovene. Ein tausend zwei hundert vier und dreissig. Tisoch dvesto shtiri in trideset. (sorry, can't produce the s and c with the hacek trivially here, replaced it with a sh and ch respectively ... ). Cheers, Andrej ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] automatic password for pg_dump to be used for a batch file in vb6
Firstly, this is the wrong list; this one is to discuss the development OF postgres, NOT with. You need novice or general. Secondly: look for pgpass in the documentation ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Companies Contributing to Open Source
On 12/20/06, Joshua D. Drake [EMAIL PROTECTED] wrote: O.k. in all Bruce I like your article but I must admit it seems to take a The community is god perspective and that we must all bend to the will of said community. I'm not really in a position to judge how a company thinks about donating resources to a project, but I certainly think that Bruce' standpoint is correct, and that the community is *indeed* the driver of a project; if a company doesn't like how the community deals with their requirements/needs they can just maintain their own branch. The community could learn a great deal from adopting some of the more common business practices when it comes to development as well. In short, I guess I think it is important to recognize that both are partners in the open source world and that to ignore one over the other is destined to fail. Do you have any statistical data to back that hypothesis? Sincerely, Joshua D. Drake Cheers, Andrej ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Companies Contributing to Open Source
On 12/20/06, Joshua D. Drake [EMAIL PROTECTED] wrote: I think my overall thought is the tone seems a bit non-gracious to companies, when IMO the community should be actively courting companies to give resources. If companies feel unwelcome, they won't give. I appreciate that, but then Bruce' aim was (or at least that's how I interpreted it) to point out difficulties that he as a long time member of the postgres hacker community sees; it would be a bit weird to expect him to write something from the perspective of a company (even though he conceivably could as an employee of enterprisedb). Of which, the community learning or my take that if we ignore one over the other it is destined to fail? I meant the failure bit, sorry for the poor quoting. I don't really want to bring up the first point as it has been hashed over and over. It lends to the project management, todo list, milestone debacle :) Amen The second point is that if the community ignores the company trying to give resources, the company is likely to ignore the community and thus we both fail (and vice versa). I guess it depends on how you define fail for a group that hasn't set its mind on making profit. Sincerely, Joshua D. Drkae Cheers, Andrej ---(end of broadcast)--- TIP 1: 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] plperl/plperlu interaction
On 10/27/06, Jim C. Nasby [EMAIL PROTECTED] wrote: Undef in Slackware 10.2 Def in Ubuntu 6.06 Undef in Mandriva 2006 Undef in Solaris 10 06 Def in SLES 9.2 Perl 5.8 in SLES 8.1 throws a fit: Array found where operator expected at /usr/lib/perl5/5.8.0/warnings.pm line 294, at end of line (Missing operator before ?) Undefined subroutine main::config_sh called at -e line 2. Perl 5.004 in solaris 67 does't doesn't do config_re, neither does the perl 5.6 in Solaris 9 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] new language translation (.po)
On 9/19/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Am Montag, 18. September 2006 15:40 schrieb Gevik Babakhani: I would like to create a language translation. Is there a procedure for that? http://pgtranslation.projects.postgresql.org/ On that note ... I haven't seen anything about translation work on the doc-list for the upcoming release, nor have I heard from Connie or Anastasios. Will there be anything happening in this regard? Cheers, Andrej ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] PostgreSQL on 64 bit Linux
On 8/21/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is there an interest, or any active project to examine PostgreSQL in the area of 64-bit processors? Has it already been done? I don't recall seeing a reference to it in my travels. I'm also not sure on what to expect for results, as the territory is still new. 64-bit processors have existed for a while, but 32-bit processors have been the popular choice, making 64-bit support an after thought? That's certainly just a reference to the wintel world? AIX, HP-UX and Solaris-Sparc have been 64-bit for a while now... Cheers, mark Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end of broadcast)--- TIP 1: 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] new job
On 8/10/06, David Fetter [EMAIL PROTECTED] wrote: Seconded! We now have a quorum. ;) Three people constitute a quorum here? That makes for a very wonky democracy. :D ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] automatic system info tool?
On 7/18/06, Bort, Paul [EMAIL PROTECTED] wrote: Mind you, maybe perl provides emulation for uname? Not that I know of. Wouldn't $^0 and $Config{archname} cover quite a few, though? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] file-locking and postmaster.pid
On 5/24/06, Andreas Joseph Krogh [EMAIL PROTECTED] wrote: My PG is not started with startup-scripts, but with this command: pg_ctl -D $PGDATA -l $PGDIR/log/logfile-`date +%Y-%m-%d`.log start ... and manually after login, ie. not at boot-time. I'd suggest trying to fix your Linux-install instead of mucking about with Postgres, and this really a pgsql-novice question, not a -hackers thing. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Need a help - Performance issues
On 5/10/06, Dhanaraj M [EMAIL PROTECTED] wrote: 2. walks through all known tuning parameters (in /etc/system and postgresql.conf) on the system 3. lists out what parameters are optimal/suboptimal for that platform, and makes recommendations. I thought that's why people still have DBAs ;} Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] advocacy
Hi Guys, Does anyone here have time to chime into this thread on LQ and give a nice spiel about PG? :) http://www.linuxquestions.org/questions/showthread.php?t=409045 Cheers, Andrej ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Updated email signature
don't feel upset, that time I already learned how to control missile :) Just curious ... how old does one need to be to be allowed that? :) I was of legal drinking age then, btw .. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] SpeedComparison
Has anyone here seen this one before? Do the values appear realistic? http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Differences in UTF8 between 8.0 and 8.1
does strip out the invalid characters. However, iconv reads the entire file into memory before it writes out any data. This is not so good for multi-gigabyte dump files and doesn't allow for it to be used in a pipe between pg_dump and psql. Anyone have any other recommendations? GNU recode might do it, but I'm a bit stymied by the syntax. A quick perl script using Text::Iconv didn't work either. I'm off to look at some other perl modules and will try to create a script so I can strip out the invalid characters. How about an ugly kludge ... split -a 3 -d -b 1048576 ../path/to/dumpfile dumpfile for i in `ls -1 dumpfile*`; do iconv -c -f UTF8 -t UTF8 $i;done cat dumpfile* new_dump Cheers, Andrej ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] [PERFORM] A Better External Sort?
On 10/6/05, Michael Stone [EMAIL PROTECTED] wrote: On Wed, Oct 05, 2005 at 11:24:07AM -0400, Luke Lonergan wrote: Nope - it would be disk wait. I said I/O overhead; i.e., it could be the overhead of calling the kernel for I/O's. E.g., the following process is having I/O problems: time dd if=/dev/sdc of=/dev/null bs=1 count=1000 1000+0 records in 1000+0 records out 1000 bytes transferred in 8.887845 seconds (1125132 bytes/sec) real0m8.889s user0m0.877s sys 0m8.010s it's not in disk wait state (in fact the whole read was cached) but it's only getting 1MB/s. Mike Stone ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings I think you only proved that dd isn't the smartest tool out there... or that using it with a blocksize of 1 byte doesn't make too much sense. [EMAIL PROTECTED]:~]$ time dd if=/dev/sr0 of=/dev/null bs=2048 count=4883 4883+0 records in 4883+0 records out real0m6.824s user0m0.010s sys 0m0.060s [EMAIL PROTECTED]:~]$ time dd if=/dev/sr0 of=/dev/null bs=1 count=1000 1000+0 records in 1000+0 records out real0m18.523s user0m7.410s sys 0m10.310s [EMAIL PROTECTED]:~]$ time dd if=/dev/sr0 of=/dev/null bs=8192 count=1220 1220+0 records in 1220+0 records out real0m6.796s user0m0.000s sys 0m0.070s That's with caching, and all. Or did I miss the point of your post completely? Interestingly, the CPU usage with the bs=1 goes up to 97%, it stays at a mellow 3% with the 8192 and 2048. Cheers, Andrej ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] Contributing
Hi Guys, I was wondering whether there's still need for people doing translations English - German ... I'd like to contribute but am not too fit in C programming, didn't do anything in ages... If this is the wrong place to ask, disregard this message :) I couldn't find any more suitable references on the website. Cheers, Andrej ---(end of broadcast)--- TIP 8: explain analyze is your friend