[no subject]
There were no other clients for that database (but there were clients in
other databases in the instance).
version is 8.1.0 . Autovacuum is off. I upped maintenance_work_mem to 512 MB
. Any hints? If nothing comes up today, I am scratching that replica.
telefony=# \d calls
Table "public.calls"
Column | Type |
Modifiers
---------------+-----------------------------+------------------------------
------------------------------
dt | timestamp without time zone |
machine_ip | integer |
port | integer |
filename | character varying(15) |
account | character(11) |
duration | integer |
ani | character(32) |
application | character(32) |
dnis | integer |
z | integer |
client | integer |
taryfa | integer |
operator | character varying(20) |
id | integer | not null default
nextval(('seq_calls_id'::text)::regclass)
outgoing | character(12) |
release_cause | text |
waiting | integer |
oper_pin | integer |
Indexes:
"calls_pkey" PRIMARY KEY, btree (id)
"calls_u" UNIQUE, btree (dt, dnis, port, machine_ip, account)
"calls_cli" btree (client, dt)
"calls_dnis" btree (dnis, dt)
"calls_z" btree (z, dt)
Triggers:
_ctele_denyaccess_5 BEFORE INSERT OR DELETE OR UPDATE ON calls FOR EACH
ROW EXECUTE PROCEDURE _ctele.denyaccess('_ctele')
Pozdrawiam
Marcin Mañk
Home |
Main Index |
Thread Index