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

Re: [PERFORM] Primary key index suddenly became very slow

2016-02-16 Thread Venkata Balaji N
On Mon, Feb 8, 2016 at 9:04 PM, Gustav Karlsson wrote: > Additional information: > > The problematic row has likely received many hot updates (100k+). Could > this be a likely explanation for the high execution time? > Query immediately after the bulk updates before VACUUM will take longer time.

Re: [PERFORM] Slow Query

2015-08-11 Thread Venkata Balaji N
e above does not help, then options to rewrite the query must be explored. Thanks, Venkata Balaji N Fujitsu Australia > > On Wed, Aug 12, 2015 at 2:09 PM, Venkata Balaji N [via PostgreSQL] <[hidden > email] <http:///user/SendEmail.jtp?type=node&node=5861850&i=0>> wr

Re: [PERFORM] Slow Query

2015-08-11 Thread Venkata Balaji N
On Wed, Aug 12, 2015 at 12:34 PM, robbyc wrote: > Hi, > > I am new to optimizing queries and i'm getting a slow running time > (~1.5secs) with the following SQL: > > SELECT distinct("Vacancy"."ID"), "Vacancy"."JobTitle", > "Vacancy"."DateCreated", "Vacancy"."CustomAccess" > , "Department"."Name"