[HACKERS] RE: [SQL] handling of database size exceeding physical disk space

2001-02-23 Thread Rini Dutta
the table and bails out of the transaction. I just wish it didn't happen so often... grin Mike Diehl, Network Monitoring Tool Devl. 284-3137 [EMAIL PROTECTED] -Original Message- From: Rini Dutta [mailto:[EMAIL PROTECTED]] Sent: February 20, 2001 9:35 AM To: [EMAIL

[HACKERS] handling of database size exceeding physical disk space

2001-02-23 Thread Rini Dutta
Hi, Does anyone know how postgres/ postmaster handles the situation where the physical hard disk space is full ? Does it crash / corrupt the database, or does it cleanly exit with appopriate message so that relevant tables can be pruned (by the user) to free up disk space and get it working

[HACKERS] how critical is WAL ?

2001-02-23 Thread Rini Dutta
Hi, I happenned to come across the following in the documentation on WAL implementation in v7.1 - * Before WAL, any crash during writing could result in: 1.index tuples pointing to non-existent table rows 2.index tuples lost in