Re: [PERFORM] pg_database_size

2016-06-14 Thread Jim Nasby
On 6/4/16 3:10 AM, Venkata Balaji N wrote: On Sat, Jun 4, 2016 at 5:35 PM, sangeetha mailto:tune2san...@gmail.com>> wrote: SELECT pg_database_size('DB1') takes 60ms for 7948 kB size DB. Is there any way to reduce the time taken or any other ways to find data base size? What is th

Re: [PERFORM] pg_database_size

2016-06-04 Thread Venkata Balaji N
On Sat, Jun 4, 2016 at 5:35 PM, sangeetha wrote: > SELECT pg_database_size('DB1') takes 60ms for 7948 kB size DB. Is there > any > way to reduce the time taken or any other ways to find data base size? What is the version of PostgreSQL you are using ? You can execute the command "\l+" which w

[PERFORM] pg_database_size

2016-06-04 Thread sangeetha
SELECT pg_database_size('DB1') takes 60ms for 7948 kB size DB. Is there any way to reduce the time taken or any other ways to find data base size? Thanks and Regards, S.Sangeetha -- View this message in context: http://postgresql.nabble.com/pg-database-size-tp5906449.html Sent from the Postgr