From: sathiya psql <sathiya.psql@gmail.com>
To: Shoaib Mir <shoaibmir@gmail.com>
Cc: A. Kretschmer <andreas.kretschmer@schollglas.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: count * performance issue
Date: Thu, 6 Mar 2008 12:01:09 +0530
Message-ID: <f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com> (raw)
In-Reply-To: <bf54be870803052226k64c3b260t632b5043f14eacdb@mail.gmail.com>
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>
<f966c2ee0803052143k4570d771o6c300647d3b987d@mail.gmail.com>
<20080306060829.GA21084@a-kretschmer.de>
<bf54be870803052215y5bb56235k5ea05ada1d701022@mail.gmail.com>
<f966c2ee0803052219x393929c4w321f65e659f1617b@mail.gmail.com>
<bf54be870803052226k64c3b260t632b5043f14eacdb@mail.gmail.com>
will you please tell, what is autovacuuming... and wat it ll do... is there
any good article in this....
On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir <shoaibmir@gmail.com> wrote:
> On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <sathiya.psql@gmail.com>
> wrote:
>
> > buy every time i need to put ANALYZE...
> > this takes the same time as count(*) takes, what is the use ??
> >
> >
> >
> Dont you have autovacuuming running in the background which is taking care
> of the analyze as well?
>
> If not then hmm turn it on and doing manual analyze then shouldnt I guess
> take much time!
>
> But yes, I will say if its possible go with the trigger option as that
> might be more helpful and a very fast way to do that.
>
>
> --
> Shoaib Mir
> Fujitsu Australia Software Technology
> shoaibm[@]fast.fujitsu.com.au
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sathiya.psql@gmail.com, shoaibmir@gmail.com, andreas.kretschmer@schollglas.com
Subject: Re: count * performance issue
In-Reply-To: <f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox