[GENERAL] performance for insert / update

2005-06-27 Thread Catalin Constantin
Hello, I have a pretty big database with about 200 000 rows. This is the main table. Also some other tables with FKs to this main table. I have to calculate some numbers for each entry at a certain amount of time and update the DB. I've noticed the update TAKES a very long time. For example i h

Re: [GENERAL] performance for insert / update

2005-06-28 Thread Bruno Wolff III
On Mon, Jun 27, 2005 at 18:46:58 +0300, Catalin Constantin <[EMAIL PROTECTED]> wrote: > Hello, > > I have a pretty big database with about 200 000 rows. > This is the main table. Also some other tables with FKs to this main > table. > > I have to calculate some numbers for each entry at a certa

Re: [GENERAL] performance for insert / update

2005-06-28 Thread Catalin Constantin
this is my "schema" for the table with the "issue" ! # \d url_importance Table "public.url_importance" Column | Type | Modifiers ---+--+- url_id| bigint | default nextval('url