From: Bahadur Singh <bahadursingh@yahoo.com>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-bugs@postgresql.org
Cc: pgsql-novice@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: BUG #1697: Select getting slower on continously updating data
Date: Fri, 3 Jun 2005 00:09:00 -0700 (PDT)
Message-ID: <20050603070900.62046.qmail@web50805.mail.yahoo.com> (raw)
In-Reply-To: <20050602130259.GB9716@wolff.to>
--- Bruno Wolff III <bruno@wolff.to> wrote:
> This does not belong on the pgsql-bugs list. The
> pgsql-novice or
> pgsql-performance lists seem more appropiate. I have
> set followups
> to the pgsql-novice list.
>
> On Thu, Jun 02, 2005 at 12:05:00 +0100,
> Bahadur Singh <bahadursingh@yahoo.com> wrote:
> >
> > Hello,
> >
> > I found situtation that, when I am selecting data
> from a table of 200
> > records, getting slower as I do continous update
> to the same existing data.
>
> You need to be vacuuming (and possibly analyzing)
> the table more often as the
> updates will leave dead rows in the table which will
> bloat the table size and
> slow down access, particularly sequential scans. If
> the updates modify the
> data value distributions significantly, then you
> will also need to
> reanalyze the table to help the planner make good
> decisions.
>
Many thanks for this tip !
But is this good idea to analyse/vacuuming the
database tables while updates are taking place..
Since, I update continuously say (100,000 ) times or
more the same data set.
This is the result of analyze command.
INFO: analyzing "public.salesarticle"
INFO: "salesarticle": scanned 3000 of 20850 pages,
containing 62 live rows and 134938 dead rows; 62 rows
in sample, 431 estimated total rows
Gesamtlaufzeit der Abfrage: 5531 ms.
Total Time Taken : 5531 ms.
Can you suggest me some clever way to so, because I
would prefer to do vaccumming while database is not
loaded with queries/transactions.
Regards
Bahadur
__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html
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: bahadursingh@yahoo.com, bruno@wolff.to, pgsql-bugs@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: BUG #1697: Select getting slower on continously updating data
In-Reply-To: <20050603070900.62046.qmail@web50805.mail.yahoo.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