By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,230 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Is it possible find a size of a table

P: n/a
Hi All,
Is it possible find the size of a pgsql table.

TIA

--
regards,
Deepa K

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
you need to install contrib/dbsize. Then you can do:
SELECT relation_size('myTable');
On Thu, 2003-11-20 at 02:30, K. Deepa wrote:
Hi All,
Is it possible find the size of a pgsql table.

TIA


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/vMa521dVnhLsBV0RAma9AJsFubohzrpbzNOi0dpNM+9d+d31yQ CePSrO
ot59VyYHZIGPt8Ho5f3Ojzw=
=AAwy
-----END PGP SIGNATURE-----

Nov 12 '05 #2

P: n/a
you need to install contrib/dbsize. Then you can do:
SELECT relation_size('myTable');
On Thu, 2003-11-20 at 02:30, K. Deepa wrote:
Hi All,
Is it possible find the size of a pgsql table.

TIA


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/vMa521dVnhLsBV0RAma9AJsFubohzrpbzNOi0dpNM+9d+d31yQ CePSrO
ot59VyYHZIGPt8Ho5f3Ojzw=
=AAwy
-----END PGP SIGNATURE-----

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.