| From: | lynch(at)lscorp(dot)com (Richard Lynch) |
|---|---|
| To: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>, Martin Schulze <joey(at)infodrom(dot)north(dot)de> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Re: More PostgreSQL stuff |
| Date: | 1998-10-02 17:15:35 |
| Message-ID: | v02140b05b23a73929ca2@[207.152.64.133] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)lscorp(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1998-10-02 17:31:18 | Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF) |
| Previous Message | Taral | 1998-10-02 16:47:48 | RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF) |