[PERFORM] High update activity, PostgreSQL vs BigDBMS

2006-12-27 Thread Guy Rouillier
I don't want to violate any license agreement by discussing performance, so I'll refer to a large, commercial PostgreSQL-compatible DBMS only as BigDBMS here. I'm trying to convince my employer to replace BigDBMS with PostgreSQL for at least some of our Java applications. As a proof of concep

Re: [PERFORM] [GENERAL] Need Help

2006-12-27 Thread Richard Broersma Jr
--- JM <[EMAIL PROTECTED]> wrote: > how can i get the disk usage for each table? can i do it via SQL? This function should do what you want: pg_relation_size(text) or pg_total_relation_size(text) I found it on the following link: http://www.postgresql.org/docs/8.2/interactive/functions-admi