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

On Wed, 12 Jan 2000, Karl DeBisschop wrote:

>
> > Anyone know if read performance on a postgres database decreases at
> > an increasing rate, as the number of stored records increase?
> >
> > 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...
>
> Are you using indexes?
>
> Are you vacuuming?
>
> I may have incorrectly inferred table sizes and such, but the behavior
> you describe seems odd - we typically work with hundreds of thousands
> of entries in our tables with good results (though things do slow down
> for the one DB we use with tens of millions of entries).

An example of a large database that ppl can see in action...the search
engine we are using on PostgreSQL, when fully populated, works out to
around 6million records... and is reasnably quick...