postgres=# select pg_relation_size('big_tab'::regclass)/1024/1024; -- IN MBs to be simple ?column? ---------- 1346 (1 row)
There are no changes in default configuration. Using unix sockets [ashutosh@ubuntu repro]ls /tmp/.s.PGSQL.5432* /tmp/.s.PGSQL.5432 /tmp/.s.PGSQL.5432.lock
Looks like a bug in psql to me. Does anybody see that behaviour?
--
Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company