Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- query:
- SELECT count(status), status from ourtable group by status ORDER BY status;
- +-------------+-----------------------------+-----------------------------------
- | Column | Type | Modifiers
- |-------------+-----------------------------+-----------------------------------
- | id | integer | not null default nextval('ourtable_id_seq'::regclass) |
- | uname | text | not null
- | essays | text |
- | questions | text |
- | details | text |
- | status | character(1) | not null default 'q'::bpchar
- | qstatus | character(1) | not null default 'q'::bpchar
- | media_wc | integer | not null default 0
- +-------------+-----------------------------+-----------------------------------
- Indexes:
- "ourtable_pkey" PRIMARY KEY, btree (id)
- "ourtable_uname_key" UNIQUE CONSTRAINT, btree (uname)
- "qstatus_idx" btree (qstatus)
- "status_idx" btree (status)
- +---------+----------+
- | count | status |
- |---------+----------|
- | 1480553 | d |
- | 458 | p |
- | 4331 | q |
- | 6347131 | s |
- +---------+----------+
- POSTGRES VERSION 9.3.9
- POSTGRES SETTINGS:
- shared_buffers = 3GB
- maintenance_work_mem = 256MB
- work_mem = 256MB
- Ran VACUUM ANALYZE to no avail.
- Takes 15 seconds.
- MySQL with default settings takes a fraction of a second after reboot.
Advertisement
Add Comment
Please, Sign In to add comment