Rod Taylor wrote:
Lets start with an example. Please send us an EXPLAIN ANALYZE of a
couple of the poorly performing queries.
thanks for your answer. the problem was solved by using FULL(!) VACUUM.
regards,
Stefan
---(end of broadcast)---
TIP 5: Have
> The database grows very slowly. The main load comes from SELECT's and
> not from INSERT's or UPDATE's, but the performance gets slower day by day...
>
> I have no idea where to search for the speed break!
Lets start with an example. Please send us an EXPLAIN ANALYZE of a
couple of the poorly p
Hi,
I operate a database server with postgres 7.3.2, 2 Xeon CPU's and 1 GB
Ram. The database-files reside on a local SCSI-HD, the system runs on
SuSE Enterprise Server 8.0.
The size of the dumped database is about 300 MB, the database is
vacuumed (-a -z) every night an reindexed every week.
Th
