Some more information, some numbers from mysql: http://www.mysql.com/information/features.html http://www.mysql.com/information/benchmarks-old.html
regards shantanu
On Thu, 16 Oct 2003 17:38:34 +0530, Raj Mathur <[EMAIL PROTECTED]> wrote:
-----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)
Comment: Processed by Mailcrypt 3.5.6 and Gnu Privacy Guard <http://www.gnupg.org/>
iD8DBQE/joo+yWjQ78xo0X8RAh/9AJ92FPCIhsOSYWwlOrgI610XI6IjtQCbBOCv apkVPv4S87Ot14c7+YDzGwo= =RF8Y -----END PGP SIGNATURE-----
_______________________________________________ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
_______________________________________________ ilugd mailing list [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd
