| From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
|---|---|
| To: | Sergei Chernev <ser(at)nsu(dot)ru>, Postgres Mailing List <pgsql-general(at)postgreSQL(dot)org> |
| Cc: | PostgreSQL Admin <pgsql-admin(at)postgreSQL(dot)org> |
| Subject: | RE: [GENERAL] Postgres speed |
| Date: | 1998-10-19 19:58:05 |
| Message-ID: | F10BB1FAF801D111829B0060971D839F484CB7@cpsmail |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilley, Charles H. | 1998-10-19 22:22:10 | 6.3.2 built, installed and running on Solaris 2.5.1.... recap |
| Previous Message | Gilley, Charles H. | 1998-10-19 19:12:53 | Compiling 6.3.2 under Solaris - pgc.l error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Mather | 1998-10-19 23:22:18 | (no subject) |
| Previous Message | David Hartwig | 1998-10-19 15:11:45 | Re: [GENERAL] Access & pgsql |