Great infomation. I didn't know that update is equal to delete+insert in
Postgres. I would be more careful on designing the database access method in
this case.
Thanks,
Alex
- Original Message -
From: "Csaba Nagy" <[EMAIL PROTECTED]>
To: "Alex Wang" &l
e are only 100 records.
Thanks,
Alex
- Original Message -
From: "Csaba Nagy" <[EMAIL PROTECTED]>
To: "Alex Wang" <[EMAIL PROTECTED]>
Cc: "postgres performance list"
Sent: Saturday, November 19, 2005 7:12 PM
Subject: Re: [PERFORM] VERY slow after
I am using PostgreSQL in an embedded system which has only 32 or 64 MB RAM
(run on PPC 266 MHz or ARM 266MHz CPU). I have a table to keep downlaod
tasks. There is a daemon keep looking up the table and fork a new process to
download data from internet.
Daemon:
. Check the table every 5 seco
