Hi, We have a problem with PostgreSQL 8.1 on a production server (Windows 2003 Server, Xeon 3GHz, 1GB)); application placed on it run for a month without problems. It was great. But yesterday... Any connection to the server, from application or pgAdmin (both previously working fine), is slow. I mean, I have to wait *minutes* for even login to succeed. Even when connecting from the same machine, with pgAdmin, with no users connected to it. Restarting the service is slow, opening the database is slow, backup is slow. Sometimes minutes, I mean. Like there was something wrong with listening for connections - sometimes I got an information that server on [my_ip_here:my_port_here] is not listening. The machine runs other services, but there is no heavy load on it and users do not have any problems with e.g. (don't shoot) MS SQL Server. Since I use IPs only, DNS issues should not be involved. There were no changes to current configuration, autovacuum is on and it seems to work, according to the log (runs every 60s). There are two tiny tables (no more than a hundred rows each, barely a database), there are only updates on them (no more than a few hundreds a day), I know it's weird but that's how it should work. I googled and searched on Groups. I'm rather new with PostgreSQL and dealing with the crashed production server is not nice :) Tommorrow I will try connection without md5 and look if the drive is OK (defragmentation?), but maybe someone has any idea, what else could I check? It is very depressing, since the database is so tiny... If nothing else helps, I will of course pg_dump, reinstall PostgreSQL server and wait for a month or so *gulp*. Thanks in advance, Bart Golda
