John Dizaro wrote:
I have to execute some times an UPDATE an some times a DELETE to register +- 50000 , every time when i do that the database be to slow do we any way to DELETE or UPDATE by part???
I'm not sure your post really contains enough information to answer your question.
If you are having problems with slow DELETEs, could it be a problem with a foreign key that lacks an index on the referencing (rather than referenced) column?
What do you mean by "to register 50000" ? Do you mean "affecting 50,000 rows" ?
Just how slow do you mean? Is the problem that the UPDATE or DELETE takes a long time, or that it slows down other queries?
-- Craig Ringer -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
