From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Wei Weng <wweng@kencast.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Seeking advice regarding a design problem
Date: Fri, 2 Aug 2002 11:24:12 -0700 (PDT)
Message-ID: <20020802112052.Y41371-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <1028305002.9763.31.camel@Monet>
On 2 Aug 2002, Wei Weng wrote:
> I am running postgresql as database backend, and I have some scripts
> dealing with constant incoming data and then insert these data into the
> database, in a quite complex way, involving a couple of procedures.
>
> But the performance of the database is worse than I had thought. After
> about 100 times of the script being run, the speed of the insertion
> slowed down dramatically. But it went back to the regular fast speed
> after I did a vacuum analyze.
>
> how can I redesign the system to avoid the bottleneck? And why is it
Upgrade to 7.2 so that you can vacuum while other things are going on
and vacuum analyze after modifying a large portion of the database (note
that if the database is particularly large you'll probably need to change
the free space map configuration as well).
It's hard to tell what particularly you're running into, is it just a
case that you're accessing the dead tuples and that's slowing it down,
is it that you're changing the data in a fashion that changes how the
optimizer should be choosing to do queries, etc...
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-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, wweng@kencast.com
Subject: Re: Seeking advice regarding a design problem
In-Reply-To: <20020802112052.Y41371-100000@megazone23.bigpanda.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