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
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
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