Re: [GENERAL] Quickly calculating row size of a table?

2005-10-26 Thread Jared Evans
Thanks very much for both your posts. I tried both: First, I performed a full vacuum on the entire database then dbn=# SELECT relname, relpages*8192/reltuples from pg_class where reltuples <> 0 and relname not like 'pg%'; atablename| 2047.95 The first SQL statement gave me a r

[GENERAL] Quickly calculating row size of a table?

2005-10-18 Thread Jared Evans
Is there a way for me to quickly calculate the maximum size of a row for a table? I wanted to know if there was an automatic way to do it before I do it manually. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an app

[GENERAL] 7.2 or 7.4 for critical data?

2004-05-06 Thread Jared Evans
Hello all, I will be installing Debian distro soon at my company. I'll be storing critical data and am wondering if I should go with stable 7.2 version or use the 7.4 version (for all the latest features and bug fixes). I'm currently doing the research for the management here. I have checked t