This should be on the ADMIN list. CC'ed THERETO...
> I've wrote a programm which operates with big table.
> The speed is ok after executing vacuum, but in some hours it goes
> 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
pgsql-admin by date
|Next:||From: Gilley, Charles H.||Date: 1998-10-19 22:22:10|
|Subject: 6.3.2 built, installed and running on Solaris 2.5.1.... recap|
|Previous:||From: Gilley, Charles H.||Date: 1998-10-19 19:12:53|
|Subject: Compiling 6.3.2 under Solaris - pgc.l error|
pgsql-general by date
|Next:||From: Andrew Mather||Date: 1998-10-19 23:22:18|
|Subject: (no subject)|
|Previous:||From: David Hartwig||Date: 1998-10-19 15:11:45|
|Subject: Re: [GENERAL] Access & pgsql|