RE: [GENERAL] Postgres speed - Mailing list pgsql-admin

From Jackson, DeJuan
Subject RE: [GENERAL] Postgres speed
Date
Msg-id F10BB1FAF801D111829B0060971D839F484CB7@cpsmail
Whole thread Raw
List pgsql-admin
This should be on the ADMIN list.  CC'ed THERETO...

> Hello,
> I've wrote a programm which operates with big table.
> The speed is ok after executing vacuum, but in some hours it goes
> down.
> What should I do to improve speed? Should I VACUUM more frequently ?
That depends on how many inserts/deletes you are performing on the
table.  It may be a better idea to redesign the table.  Now, I can't
tell you exactly what to do because you didn't give us a whole lot to
work with.

> Thanx,
You're welcome.
    -DEJ

pgsql-admin by date:

Previous
From: "Gilley, Charles H."
Date:
Subject: Compiling 6.3.2 under Solaris - pgc.l error
Next
From: "Gilley, Charles H."
Date:
Subject: 6.3.2 built, installed and running on Solaris 2.5.1.... recap