Re: [GENERAL] identifying performance hits: how to ???

Have/do you perform reasonably regular vacuum's of the database?

Do you make use of indices to increase SELECT/UPDATE performance?

Have you checked out your queries using psql+EXPLAIN, to see that said
indices are being used?

What operating system are you using?  hardware?

How are you starting up the postmaster?


On Wed, 12 Jan 2000, Robert Wagner wrote:

> Hello All,
>
> Anyone know if read performance on a postgres database decreases at an
> increasing rate, as the number of stored records increase?
>
> This is a TCL app, which makes entries into a single, table and from time
> to time repopulates a grid control.  It must rebuild the data in the grid
> control, because other clients have since written to the same table.
>
> It seems as if I'm missing something fundamental... maybe I am... is some
> kind of database cleanup necessary?   With less than ten records, the grid
> populates very quickly.  Beyond that, performance slows to a crawl, until
> it _seems_ that every new record doubles the time needed to retrieve the
> records.  My quick fix was to cache the data locally in TCL, and only
> retrieve changed data from the database.  But now as client demand
> increases, as well as the number of clients making changes to the table,
> I'm reaching the bottleneck again.
>
> The client asked me yesterday to start evaluating "more mainstream"
> databases, which means that they're pissed off.  Postgres is fun to work
> with, but it's hard to learn about, and hard to justify to clients.
>
> By the way, I have experimented with populating the exact same grid control
> on Windows NT, using MS Access (TCL runs just about anywhere).  The grid
> seemed to populate just about instantaneously.  So, is the bottleneck in
> Unix, in Postgres, and does anybody know how to make it faster?
>
> Cheers,
> Rob
>
>
>
> ************
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org