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

Re: [PERFORM] [GENERAL] need help

2005-12-21 Thread Alban Medici \(NetCentrex\)
t: mardi 6 décembre 2005 09:55 To: Jenny Cc: pgsql-general@postgresql.org; pgsql-sql@postgresql.org; pgsql-performance@postgresql.org Subject: Re: [PERFORM] [GENERAL] need help Jenny schrieb: > I'm running PostgreSQL 8.0.3 on i686-pc-linux-gnu (Fedora Core 2). > I've been dealing

Re: [PERFORM] [GENERAL] need help

2005-12-06 Thread Tino Wildenhain
Jenny schrieb: I'm running PostgreSQL 8.0.3 on i686-pc-linux-gnu (Fedora Core 2). I've been dealing with Psql for over than 2 years now, but I've never had this case before. I have a table that has about 20 rows in it. Table "public.s_apotik" Column | Type