On Wed, 2003-09-03 at 15:32, Naveen Palavalli wrote:
> shared_buffers = 200

If you're using a relatively modern machine, this is probably on the low
side.
 
> 1) Effects related to Vaccum :- I performed 10 trials of adding and
> deleting entries . In each trial , 1 client  adds 10,000 entries and
> then deletes them . During the course of these 10 trials ,  the Add
> Rates (rate at which my server can add entries to the Postgresql
> database ) drops from  around 200 Adds/second in the 1st trial  to
> around 100 Adds/second in the 10th trial . But when I do a Vaccuum ,
> Immediately I get back the Add Rates to  around 200 Adds/Second .

Well, there's nothing wrong with vacuuming frequently (since it won't
block concurrent database operations, and the more often you vacuum, the
less time each vacuum takes).
 
> I was using Postgresql 7.3.3 earlier but it kept crashing the database
> after a Vaccum . So I switched to a older and stabler version  7.2.4

Can you reproduce the 7.3.3 crash? (BTW, in the future, it would be
appreciated if you could report these kinds of bugs to the dev team).

-Neil



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to