Re: [ilugd] New resource - Skip a burger at McDonalds get a KNOPPIX 3.2 bootable CD
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Oct 17, 2003 at 11:31:46PM +0530, [EMAIL PROTECTED] wrote: mayank2coolResource ID: 63 mayank2coolTitle: Skip a burger at McDonalds get a KNOPPIX 3.2 bootable CD he he I like the sales pitch. Do i get a cola with it? :) - -- all the things we keep inside, are the things that really matter, the face puts on its best disguise, and all is well, until the heart betrays. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/kRoC7v3NbZTFJeIRAugqAJ9ke81qfkhVl121hqgZA00AzPE/ywCgrfDH 7/c5CwhJ3mxXgqx3SQj6EYY= =k0CG -END PGP SIGNATURE- ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
[ilugd] [OT] [HUMOUR] What if the I.T. industry starts producing movies?
Couldn't resist this one... I was incapacitated ROTFL for 10 minutes after reading it! -- Raju What if the I.T. industry starts producing movies? Some film titles may be like these: * Network Ke Us Paar * Meri Disc Tumhare Paas Hai * Aao Chat Kare * Programmer No.1 * Mera Naam Developer * Java Wale Job Le Jayenge * Hum Apke Memory Mein Rahate Hein * Do Processor, Baarah Terminal * Tera Code Chal Gaya * Har Din Jo Mail Karega * Debugging Koi Khel Nahi * Jish Desh Mein Bill Gates Rehatha Hai * Raju Ban Gaya MCSE * Client Ek Numbari, Programmer Dus Numbari * Login Karo Sajana * Naukar PC Ka * 1942 -- A Bug Story * Kaho Na Virus Hai * Crash Se Crash Tak * Haan Meine Bhi Debug Kiya Hai * Shaheed Hacker Singh * Password De Ke Dekho * Terminal Apna , Login Parayi * Mr. Network Lal * Terminal Sajaake Rakhna * Hackers Ka Raja, Debuggers Ki Rani * Kyonki Mein Debug Nahin Kartha * Phir Theri Java-script Yaad Aayi * Hang To Hona Hi Tha -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F It is the mind that moves ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
RE: [ilugd] Postgres vs oracle
Incidentally, this is also true for most commerical databases. The space of delete rows is not returned to OS automatically. while shutting down the database is not necessary but trying to return space back to OS does have a significant performance penalty and is not recommeneded on productions systems (at least in oracle and SQL Server). Tarun -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gurpreet Singh Sachdeva Sent: Saturday, October 18, 2003 2:10 AM To: The Linux-Delhi mailing list; The Linux-Delhi mailing list Subject: RE: [ilugd] Postgres vs oracle Correct! To be more precise: The standard form of VACUUM is best used with the goal of maintaining a fairly level steady-state usage of disk space. The standard form finds old tuples and makes their space available for re-use within the table, but it does not try very hard to shorten the table file and return disk space to the operating system. If you need to return disk space to the operating system you can use VACUUM FULL --- but what's the point of releasing disk space that will only have to be allocated again soon? Moderately frequent standard VACUUMs are a better approach than infrequent VACUUM FULLs for maintaining heavily-updated tables. Recommended practice for most sites is to schedule a database-wide VACUUM once a day at a lowusage time of day, supplemented by more frequent vacuuming of heavily-updated tables if necessary. (If you have multiple databases in an installation, don't forget to vacuum each one; the vacuumdb script may be helpful.) Use plain VACUUM, not VACUUM FULL, for routine vacuuming for space recovery. VACUUM FULL is recommended for cases where you know you have deleted the majority of tuples in a table, so that the steady-state size of the table can be shrunk substantially with VACUUM FULL's more aggressive approach. If you have a table whose contents are deleted completely every so often, consider doing it with TRUNCATE rather than using DELETE followed by VACUUM. Gurpreet Singh Sachdeva -Original Message- From: Raj Mathur [mailto:[EMAIL PROTECTED] Sent: Thu 10/16/2003 5:38 PM To: The Linux-Delhi mailing list Cc: Subject: Re: [ilugd] Postgres vs oracle -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ambar == Ambar Roy [EMAIL PROTECTED] writes: Surely NO...so we would certainly be interested to know some of your Ambar Biggest Internet Sites running on open source. Geocrawler use Postgres. Ambar Intresting thing about Geocrawler AudioGalaxy using Ambar postgres was that both of these sites seemed to go offline Ambar for daily maintainence during the middle of the day here in Ambar India. Both the sites ran Postgresql, and were probably Ambar running a daily database cleanup. IMHO this is what has Ambar kept me away from considering postgresql for serious Ambar databases. Has this issue of regular database maintainence Ambar been solved by the recent versions of postgresql? PostgreSQL (PgSQL) has two types of ``cleanup'': vacuum and vacuum full. The first (plain vacuum) merely marked unused (deleted) disk clusters as free but does not compact the physical database. The second (vacuum full) does all that and also physically compacts the database on disk. Using vacuum full will lock up your database, no queries or transactions will be possible while it is running. However most databases achieve a sort of `steady state' (roughly the same number of records being added and deleted regularly) and plain vacuum suffices for that. Transactions are possible during vacuum, and most installations will prefer to use that periodically over vacuum full. It's only if your database sizes vary wildly over the course of time that you'll need to use vacuum full (and consequently bring the system down for maintenance). The above is from my understanding of PgSQL, would appreciate clarifications in case I've missed anything out. Ambar Another intresting thing about postgresql is that while the Ambar web hosting control panels on Linux used to only support Ambar MySQL, cPanel Plesk now have support for Postgresql. To Ambar me this is a good sign. Now even smaller sites can start Ambar using Postgresql. Regards, - -- Raju - -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F It is the mind that moves -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux)
RE: [ilugd] Postgres vs oracle
Did some research over the weekend. First of all some good news: Heavy duty sites that run Postgres include; A) RubyForge (rubyforge.org). They have 300K records. Not too many but moderately high. B) .org domain. c) sourceforge used to run postgres. AFAIK, they moved out because IBM made that a condition for funding them and not because of any issues with postgres. Now, the bad news: Postgres is still not clusterable. What postgres calls clustering is using triggers to copy data from one server to another. This is not what is usually meant by database clusters. There would be no good way to handle globally unique columns or handle conflicting writes and transactions in general. (If you call using triggers and copy clustering. I have a geographically distributed mysql cluster that uses rsync and cron !!) When I say database cluster, I mean that you put a bullet thru one of the servers while your query is running and your query still returns the right results as if nothing happened. This can be achieved by something like mounting RAID-5 (or raid-10) (software or hardware) on two postgres boxes to somehow mirror data over two servers and the two servers somehow aware which of them is writing which block so that they do not knock each other's writes. Seems like that is pretty far away. To be precise, it is not really RAID but actually raid-like-transparent-mirroring-over-network and does not exist in mainstream linux kernel. However, it seems oracle is giving similar technology (called OpenGFS)(http://otn.oracle.com/tech/linux/open_source.html) as well as tools to run this kind of network over firewire or fibre. (100 Mbps might end up being too slow for such an exercise). IMHO, oracle is giving this technology away so that they can sell more RAC licenses on linux. However, oracle or not, I would prefer seeing something similar to OpenGFS integrated into main stream kernel (I believe the closest today in mainstream kernel would be mounting network block devices in somekind of software RAID volumes). Other than clustering, things that are currently not in postges but exists in oracle: A) materialized views (views that are calculated early on and not just-in-time) B) index-organized tables (where the entire table is in index. Great for performance on narrow tables) C) database links (this is linking columns to point at values in other databases) D) point-in-time recovery (restore database state to as on XXX) E) nested transactions F) savepoint G) good cursor support (Right now executing a query fetches the entire result set in memory. This is not scalable). This is easy to do for simple cases but probably very difficult for queries inside transactions H) execute batch /bulk updates etc. (there is copy but that is not standard) i) peripheral tools. Lot of people use oracle forms and reports. I have not heard of anything similar for postgres. It would be also nice to have some good migration tools. J) tablespaces K) multi-column function-based indexes Many things just came in 7.3 and are not completely tested. They inculded: A) stored procedures that can return result sets (table functions) B) schema support C) prepared queries D) dependancy tracking E) good secuirty and priviledge model (before 7.3 it was rather elementary) F) improved internationalization support (this still has to go some way) tarun ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
[ilugd] PostgreSQL benchmarks
hi, could someone post a link to a site that has above data vis-a-vis Oracle, MySQL ? tia sankarshan - The Ankur Bangla Project www.bengalinux.org Bringing Bangla to the GNU/Linux desktop - --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 10/16/2003 ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [OT] [HUMOUR] What if the I.T. industry starts producing movies?
On Mon, 2003-10-20 at 00:01, Raj Mathur wrote: Couldn't resist this one... I was incapacitated ROTFL for 10 minutes after reading it! -- Raju What if the I.T. industry starts producing movies? Some film titles may be like these: * Network Ke Us Paar * Meri Disc Tumhare Paas Hai Snip I doubt if the full names of the movies would be displayed. Most probably they would have acronyms spewed across the posters. For eg. NKUP ( Network Ke Us Paar) featuring our proprietary star AB HM. -- / \__ (@\___Raj Shekhar / O My home : http://geocities.com/lunatech3007/ / (_/My blog : http://lunatech.journalspace.com/ /_/ U ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
[ilugd] Re: qmail in FreeBSD
check the tcp.smtp or which ever file is controlling your tcp qmail rules database. For every host that you want to give the access to, there sould be a line in this file. Or else put `:allow' in the last line for everyone to able to connect. In case you want it to relay it for everybody, set the RELAYCLIENT env variable on that line. -js keshab wrote: Hi, We have a remote FreeBSD server where qmail should be configured. I' ve done the necessary qmail configuration and settings over there. Now being in the server prompt itself I can connect to its 25 port thru telnet but not from remotely, i.e. from another server in my local network. Can any one give some hints why this is not working? ciao keshab ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
[ilugd] (fwd) Want to know about linux Books
[Please CC replies to the original poster -- Raju] This is an RFC 1153 digest. (1 message) -- MIME-Version: 1.0 Content-type: multipart/alternative; boundary=Next_1066619617---0-203.199.83.246-18845 Message-ID: [EMAIL PROTECTED] From: Ishtiyaq A Choudhary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Want to know about linux Books Date: Mon, 20 Oct 2003 08:42:37 +0530 This is a multipart mime message --Next_1066619617---0-203.199.83.246-18845 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello,=0A=0AOur Schools is at Mumbai city and we want to merge the Linux ed= ucation in our School, There are some distributions we found for schools, s= uch as K12LTSP, DEBIAN JUNIOR or else. But the problem is, we are unable to= locate any book related with these distributions.=0A=0AWe need opensource = people help in this matter that what should we do now and how to proceed fu= rther in this subject.=0A=0AJust now we are seeking basic linux-based book = for primary Students as well as books for Secondary students.=0A=0ARegards:= Ishtiyaq Choudhary. --Next_1066619617---0-203.199.83.246-18845-- -- End of this Digest ** -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F It is the mind that moves ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] Re: qmail in FreeBSD
Hi Thanks for ur info. yeah, :allow is there in the last line. Still I'm unable to connect the 25 or 110 port remotely. What to set in RELAYCLIENT env variable and how? Can it be a problem of firewall rule setting? ciao keshab On Mon, 2003-10-20 at 10:01, Jasmeet wrote: check the tcp.smtp or which ever file is controlling your tcp qmail rules database. For every host that you want to give the access to, there sould be a line in this file. Or else put `:allow' in the last line for everyone to able to connect. In case you want it to relay it for everybody, set the RELAYCLIENT env variable on that line. -js keshab wrote: Hi, We have a remote FreeBSD server where qmail should be configured. I' ve done the necessary qmail configuration and settings over there. Now being in the server prompt itself I can connect to its 25 port thru telnet but not from remotely, i.e. from another server in my local network. Can any one give some hints why this is not working? ciao keshab ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd