From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Robert Wagner <rwagner(at)siac(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, squires(at)com(dot)net |
Subject: | Re: [GENERAL] identifying performance hits: how to ??? |
Date: | 2000-01-12 16:23:23 |
Message-ID: | Pine.BSF.4.21.0001121221320.46499-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Cory Kempf | 2000-01-12 16:23:35 | Re: postgresql installation |
Previous Message | Karl DeBisschop | 2000-01-12 16:22:13 | Re: [GENERAL] identifying performance hits: how to ??? |