-----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
