[HACKERS] Implicit order-by in Postgresql?

2001-06-11 Thread earthlink
Frequently one wants a data set returned in the same order as the index used in the query. Informix (at least) has implicit order-by, which means that the data will be returned in collating order if the query forces use of the appropriate index. Does Postgresql do this? If not, does an Order-by

[HACKERS] Internal pointers clobbered on system crash without fsync???

2001-06-11 Thread earthlink
If one runs Postgresql with fsync turned off in order to get better performance, is there a risk that the database internals will be damaged by a system crash? I realize that database discrepancies are possible, but I am referring to a failure where storage allocation gets messed up, or critical i