I just moved in as system administrator at a small
ISP. We have a postgresql database to keep track of
user logins, for example to see if a new user has not
used the account and so might be having trouble
getting it set up. Anyway, the db, called radiusdb,
grows fairly quickly. What we'd like to d
I've got a large database that's getting too big. I
checked with the users and deleted approximately 1/6th
of the records (we have archived backups) and then ran
a VACUUM, which took a really long time to complete
(several days). But, the disk space usage doesn't seem
to have changed. Do I need to
Sorry, I realize now that my original post was very
unclear. I read the FAQ and therefore know that just
running VACUUM will not show decreased disk usage.
However, I would expect that after deleting 1/6 of the
db and running vacuum, the db would quit growing on
the disk (except for maybe some log
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> anybody has an experience how is stable postgresql
under Windows
system ?
> I tried postgresq 7.1 under Cygwin, Windows 98 and
was dissapointed
> by very bad performance.
As you might guess, Cygwin's speed depends heavily on
the version of Windows yo