Re: [PERFORM] index fragmentation on insert-only table with non-unique column

On Fri, Jun 3, 2016 at 6:54 PM, Justin Pryzby wrote: > max_wal_size| 4GB | configuration file > min_wal_size| 6GB | configuration file Just a minor digression -- it generally doesn't make sense to configure the minimum for somethi

Re: [PERFORM] pg_database_size

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

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