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

29m
comment Materialized Views and Indexes
Abelisto is right. For such a tiny table an index will never be used.
1h
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
10h
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
19h
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
19h
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
21h
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
21h
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
comment Creating mini postgresql dump
This tool claims to be able to do that: jailer.sourceforge.net
May
1
comment Trigger function - PostgreSQL 9.2
If the column can't be null, then why don't you just define it as NOT NULL and a default value?
Apr
30
comment PL/pgSQL trigger function syntax error at END;
ELSE IF --> ELSIF: postgresql.org/docs/current/static/…
Apr
30
comment Security of streaming replication?
No. With streaming replication the WAL segments are sent directly to the slave through a regular connection, not by writing files.
Apr
29
comment Security of streaming replication?
That wouldn't be streaming replication. That's just WAL shipping, isn't it?
Apr
28
comment Make a (copy of a) postgis database available to customer?
Create a hot-standby with streaming replication: postgresql.org/docs/current/static/…
Apr
27
comment Extract string in PostgreSQL 9.2
You are right it does not need to be that complicated (or tricky). A simple split_part() will do.
Apr
27
comment Extract string in PostgreSQL 9.2
meta.stackoverflow.com/questions/285551/…
Apr
26
comment Automatic index creation for primary vs. foreign keys in Postgresql
Oracle, SQL Server, DB2 or Firebird also don't automatically create indexes for FK columns
Apr
25
comment Postgresql with just index storage
That's very likely, yes. You can check that for yourself by looking at pg_statio_user_tables
Apr
25
comment Postgresql with just index storage
What you are asking for is known in Oracle as "index organized table" or "clustered index" in other DBMS. Postgres simply doesn't support that, there is no workaround
Apr
25
comment Most efficient way to retrieve data by timestamps
Abelisto is right. Your query only takes 250 milli seconds on the server. If you see 20 seconds as the runtime, then it's the time to either transfer the data over the network (although that seems really long for 20000 rows) or it's your SQL client (or application) that takes 20 seconds to display those rows.