Majid Azimi <majid.merkava@xxxxxxxxx> wrote: > ran VACUUM ANALYZE on it(it is not VACUUM FULL). but this cause > the database to completely block. Please show the results from running the query here: http://wiki.postgresql.org/wiki/Server_Configuration -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin