Thread: Re: [GENERAL] Re: More PostgreSQL stuff

Re: [GENERAL] Re: More PostgreSQL stuff

From
lynch@lscorp.com (Richard Lynch)
Date:
At 8:20 AM 10/2/98, Oliver Elphick wrote:
>Copied to PostgreSQL lists, in the hope of comments from the experts...
>
>Martin Schulze wrote:
>  >Is there a way to speed up postgres?  I'm converting one of my
>  >major apps from mSQL to PostgreSQL and PostgreSQL is at least three
>  >times slower.  That's horrible.  With this slowlyness I cannot
>  >install PostgreSQL in the office but only at home.

Also be sure that you have indexed the fields you use most for queries.

And be sure to do a vaccuum after major data insertion/updates.

--
--
-- "TANSTAAFL" Rich lynch@lscorp.com



Re: [GENERAL] Re: More PostgreSQL stuff

From
Martin Schulze
Date:
Richard Lynch wrote:
> At 8:20 AM 10/2/98, Oliver Elphick wrote:
> >Copied to PostgreSQL lists, in the hope of comments from the experts...
> >
> >Martin Schulze wrote:
> >  >Is there a way to speed up postgres?  I'm converting one of my
> >  >major apps from mSQL to PostgreSQL and PostgreSQL is at least three
> >  >times slower.  That's horrible.  With this slowlyness I cannot
> >  >install PostgreSQL in the office but only at home.
>
> Also be sure that you have indexed the fields you use most for queries.

I mainly use queries with "WHERE nr = %d" and nr is an index
field.

> And be sure to do a vaccuum after major data insertion/updates.

I haven't done this.  *This* was a *very* good idea.  First
tries showed that PostgreSQL is only 1/3 slower than the old SQL
database.  This is much more acceptable.

Thank you very much.

Regards,

    Joey

--
A mathematician is a machine for converting coffee into theorems.