[PERFORM] Slow counting on v9.3

2014-01-15 Thread Kai Sellgren
ounts without filters. This performs quickly: SELECT reltuples AS count FROM pg_class WHERE relname = 'NewsArticle'; But I'd like to add conditions so I don't like the last method. -- Yours sincerely, Kai Sellgren

[PERFORM] Issue with query scanning through all data even with indexes

2014-01-15 Thread Kai Sellgren
ideas? All of them are appreciated! Cheers, -- Yours sincerely, Kai Sellgren

[PERFORM] Optimizing a query

2013-12-19 Thread Kai Sellgren
Log_targetId_targetType_idx" ON "Log" USING btree ("targetId", "targetType" COLLATE pg_catalog."default"); I have ran Vacuum and Analyze on both tables. What am I missing here? -- Yours sincerely, Kai Sellgren