Reputation
20,020
Top tag
Next privilege 25,000 Rep.
Access to site analytics
Badges
4 37 71
Newest
 index
Impact
~1.5m people reached

8h
comment Materialized Views and Indexes
Abelisto is right. For such a tiny table an index will never be used.
8h
comment How to upgrade PostgreSQL 7.3 to 9.3?
Your only chance is a dump/reload: postgresql.org/docs/current/static/backup-dump.html
18h
comment ORA-00932 on subquery join from subquery join
Not the reason for the error, but: all those derived tables are useless and can be replaced with a simple reference to the base table used inside them. FROM kbq_ent JOIN entity_vuln ON ... JOIN entity_responsible_org anon_2 ON ... WHERE entity_responsible_org.org_id = :org_id_1
20h
revised Justified multi-value field in MySQL?
edited tags; edited tags
1d
revised Order by in json field in Postgres and using django
deleted 5 characters in body; edited tags; edited title
1d
comment Who deleted a record?
There is no built-in feature. But you can add triggers that will do that for you: okbob.blogspot.co.uk/2015/01/… or 8kb.co.uk/blog/2015/01/19/… or github.com/wingspan/wingspan-auditing
1d
comment re-installing same version of Postgres to keep the data
What exactly is "wrong with the service"? You could simply delete and re-create (only) the service using pg_ctl
1d
comment Index for column with two possible value
For a condition that would select half of the rows an index lookup won't make things faster. And please read: wiki.postgresql.org/wiki/SlowQueryQuestions then edit your question and add the missing information
1d
comment Track updated columns postgresql trigger?
Cross post: stackoverflow.com/q/37026181/330315
1d
comment SQL DB - Login ID inserted in audits
Which DBMS are you talking about?
2d
revised Service Desk SLA Report
added 225 characters in body; edited tags
2d
revised Disk Space issue
edited tags
2d
revised Poor performance of JOIN, WHERE, ORDER BY combination (MySQL)
edited tags
2d
revised How to append datetime in filename in postgresql
added 4 characters in body
2d
awarded  index
May
2
answered Missing / Orphan Indexes?
May
2
revised Looking for a better way with Reporting Db server
edited tags
May
2
answered Is there a way in PostgreSQL to set an default owner for all future create table statements in a session
May
2
revised Is there a way in PostgreSQL to set an default owner for all future create table statements in a session
deleted 23 characters in body; edited tags; edited title
May
2
comment Creating mini postgresql dump
This tool claims to be able to do that: jailer.sourceforge.net