|
after my update
I had my entire data drectory PGDATA
removed,
i had done initdb again
and did lot of inserts (the inserts have
given the similar performance)
i then do a remove from the db, which is
taking time.
when i had postgres 8.0.0 i did not turn
fsyn off.
that time i had moved the pg_xlog directory
to a diff partition and created a link from PGDATA to its new
location.
(i did this because i had heard tha it
boosts performanne)
but I am doing the same here also (i mean
with Postgres 8.1.5)
the only thing that i havent changed is the
jdbc jar
which is still the one that i used with
Postgres 8.0.0
(but will that make it slow?)
thanks,
surabhi
From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Ben Trewern Sent: Wed 11/29/2006 7:13 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] sudden drop in delete performance Did you 'vacuum analyze' after you did the
update?
Make sure you have the correct indexes in place on
your foreign keys.
Did you have fsync off on your previous
installation?
Give some more details and I'm sure people will be
able to give better advice than me.
Regards,
Ben
|
