Re: [HACKERS] Thesis on PostgreSQL
On Thu, Sep 02, 2004 at 02:12:43PM +0200, Peter Eisentraut wrote: Am Donnerstag, 2. September 2004 13:00 schrieb Eyinagho Newton: Part of my final year thesis involves creating a database using PostgreSQL. As a way of documentation, is it correct to say that PosgreSQL belongs to the fifth generation of database management systems? Where does MySQL fall into? The fourth generation? I'm not aware of any generally accepted definitions of generations of database management systems. Nor am I, but I'd say MySQL would be at least 2 if not 3 or 4 generations behind PostgreSQL if there was such a thing :). PostgreSQL would also be a generation or two behind Oracle. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: Where do you want to go today? Linux: Where do you want to go tomorrow? FreeBSD: Are you guys coming, or what? ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] [PATCHES] pgxs default installation + various fixes
On Fri, Sep 03, 2004 at 10:42:30AM +0200, Fabien COELHO wrote: As I'm into these files, I can say that one of the reason for that is that the shell scripts in the makefile looks inefficient, with nested for-loops and one-at-a-time config/install-sh forked-script copies for 350 header files, on the 971 files of a standard installation. Also the install-sh script apparently is way more complex than it needs to be. There's probably a lot of that complexity (and subsequent slowness) that install-all-headers doesn't need. A lot of time goes into processing the script itself rather than doing useful work. Is there an objection to trying to convert it to a simpler, faster alternative? Maybe even one that receives multiple files as arguments, which would reduce the number of times it is called by an order of magnitude. -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) Schwern It does it in a really, really complicated way crab why does it need to be complicated? Schwern Because it's MakeMaker. ---(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] [PATCHES] pgxs default installation + various fixes
Dear Tom, dear Peter, By my count it adds about 2 megabytes to the installed footprint, which perhaps is not so much now as it was at the time. Ok. I agree. I'm investigating on how to do that, and the choice will be to committers. A larger problem from my point of view is that the installation process seems quite inefficient. make install-all-headers takes a full minute on my devel machine, which is above my threshold of pain for something that I often do more than once a day. As I'm into these files, I can say that one of the reason for that is that the shell scripts in the makefile looks inefficient, with nested for-loops and one-at-a-time config/install-sh forked-script copies for 350 header files, on the 971 files of a standard installation. I guess it a deliberate portability choice that only standard shell and file wildcards are used. I'm not sure there is a simple and *portable* performance fix on the installation. Some files are copied more that once: for instance, pg_config.h is copied both in include/ and include/server, and there are others examples file that. In fact, all files and directories under include/ but include/server seems also copied into include/server. It seems to be a 200KB and 28 files replication. Not really big deal, but not really clean either. If there is only one installation target which includes all header files, ISTM that the include/server subdirectory does not make much sense anymore? On the other hand, it might help packagers to have a clear list of the use of all headers files, in order that they can figure out where they belong to. Opinions? -- Fabien Coelho - [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] www.postgresql.org hacked ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, what is that: myGeek balance authentication page ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBOG3A7UpzwH2SGd4RAkfDAJ95/Y/XnOoMlY/e+YTgYbV6fox6kACfaDiF 4Fd3kQpEj/rFBA7XJSK4cj0= =HO9x -END PGP SIGNATURE- ---(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] version upgrade
I'm quite sure that the schema change will not hurt nothing. However I have to say that add come column, with default value and a check on it is no to doable with very bigtables. Fortunately with the 8.0 you can do these tasks in one shot. I've got a few 30GB tables anxiously awaiting that single alter command that will alter in all the stuff that should have been added a long time ago. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [PATCHES] pgxs default installation + various fixes
Fabien COELHO [EMAIL PROTECTED] writes: For instance, apache looks for a bsd install program at configuration time... and a slow but compatible shell substitute is used instead if none is available. We used to do that, and gave up on it because there was too much variability in the available install programs. regards, tom lane ---(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
[HACKERS] Bug in numeric modulo operation remains
This bug was heavily commented on but the behavior was never changed: Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit alvherre=# select 123456789012345678901234567890 % 123; ?column? -- -6 (1 fila) The most relevant part of the thread is here: http://archives.postgresql.org/pgsql-general/2004-04/msg01065.php -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) Thou shalt check the array bounds of all strings (indeed, all arrays), for surely where thou typest foo someone someday shall type supercalifragilisticexpialidocious (5th Commandment for C programmers) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Developers page is down
Hi guys i was looking for the http://developer.postgresql.org/todo.php in order to view what things are you posponing for later versions but the entire developer.postgresql.org site is down. By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. thanx in advance, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
