Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

[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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2007 PostgreSQL Global Development Group