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

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

2001-02-23 Thread Rini Dutta
lains that it can't extend the > table and bails out of > the transaction. I just wish it didn't happen so > often... > > Mike Diehl, > Network Monitoring Tool Devl. > 284-3137 > [EMAIL PROTECTED] > > > > -Original Message- > > From

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

[HACKERS] foreign key introduces unnecessary locking ?

2000-10-09 Thread Rini Dutta
Hi, When two tables (table2 and table3) have foreign keys referring to a common table(table1), I am unable to have 2 concurrent transactions - one performing insert on table1 and the other on table2, when the records being inserted have the same foreign key. If I use JDBC, one of the transactio