From: | Charles Day <chaday(at)symix(dot)com> |
---|---|
To: | "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | updating database |
Date: | 1998-11-04 16:26:29 |
Message-ID: | 01EAC2C24C98CF119E7A00009291330502E89151@mailman.bkb.symix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
We have a knowledge base that needs updated every night from a text file.
Currently a script deletes everything from a table and adds the new data.
This procedure seems to slowly cause the database to loose performance
daily. It also leaves our database useless for several hours starting at
midnight. I thought about using 2 databases, updating one while using the
other, then swapping them every day. I also thought about having one
db.out, then the other in.
Is there a better way to do this?
Thanks in advance.
Charles Day
From | Date | Subject | |
---|---|---|---|
Next Message | rony khoury | 1998-11-05 06:32:40 | select b[1] from foo |
Previous Message | G.Elangovan | 1998-11-04 14:29:45 | Re: [SQL] How can I optimize a research on text field? |