On Sat, 19 Jul 2003, Jeremy M. Guthrie wrote:
> 100megs of new data each day. However, the instant the system finishes only
> a 'vacuum analyze', the whole thing slows WAY down to where each run can take
> 10-15 minutes.
Have you run EXPLAIN ANALYZE on the delete query before and after the
va
"Jeremy M. Guthrie" <[EMAIL PROTECTED]> writes:
> My system will run great after a full vacuum(as I would expect). It will run
> all day long taking only 3-5 seconds to run and deal with approximately
> 100megs of new data each day. However, the instant the system finishes only
> a 'vacu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I have an application I wrote that uses two tables heavily. The first table
is a queue table, the second table is an archive table. The queue table is
constantly taking on new records at the rate of 10/second. My software pulls
th
I currently have a J2EE app that allows our users to upload files. The
actual file gets stored on the same disk as the webserver is running
on, while the information they entered about the file gets stored in
the database. We now need to move the database to a different machine
and I'm wonder
