Gustavo Henrique wrote:
>
> First of all,
> Let me say I dont have much experience with postgresql and I've
> done only few tests, so excuse me for any wrong comments i make.
>
> I think the following things should be improved in postgresql now:
>
> - reliability
Have you had real reliability issues or theoretical ones ?
On what version ?
> - Documentation
Could you be more specific ?
What is it you are missing in docs - maybe better organization ?
>
> Sometimes a table doesnt exist anymore but it's still listed in
> pg_class table, or the opposite,
Does it happen under normal use or must you do some of the dirty
tricks with "flush off" ?
> or you did a physical backup and you wanna
> restore the db, and other things that could be improved and more documented.
>
> Some crashes we tested (like powering down the system while
> running with flush off) were just fatal to some tables,
Yes with "flush off" they are supposed to be fatal.
Flush off is a performance hack for computers with UPSes.
>
> I also miss something like mysql's isamchk
What does it do ?
> and a better control of the security, with 1 system table
> controlling passwords, hosts allowed and denied, and
> anything for the users of all databases.
Currently this is held in pg_hba.conf mainly due to performance issues.
(IMHO these performance issues would really be an issue under DoS attack
;)
> just my 2 cents......
Thanks!
--------
Hannu