Re: sudden drop in delete performance
| От | surabhi.ahuja |
|---|---|
| Тема | Re: sudden drop in delete performance |
| Дата | |
| Msg-id | 8626C1B7EB748940BCDD7596134632BE3986BE@jal.iiitb.ac.in обсуждение исходный текст |
| Ответ на | sudden drop in delete performance ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>) |
| Ответы |
Re: sudden drop in delete performance
Re: sudden drop in delete performance |
| Список | pgsql-general |
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@postgresql.org on behalf of Ben Trewern
Sent: Wed 11/29/2006 7:13 PM
To: pgsql-general@postgresql.org
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
""surabhi.ahuja"" <surabhi.ahuja@iiitb.ac.in> wrote in message news:8626C1B7EB748940BCDD7596134632BE3986BB@jal.iiitb.ac.in...I was using Postgres 8.0.0I have upgraded it to Postgres 8.1.5I have seen that the delete performance has degraded considerably.Nothing else has changed.Please helpthanksregardsSurabhi
В списке pgsql-general по дате отправления: