Reputation
28,266
Next tag badge:
95/100 score
21/20 answers
Badges
3 42 80
Newest
 Copy Editor
Impact
~973k people reached

2d
comment How to use aggregate function and group by with inner join? (Postgres 9.3)
Your query should work. there must be something going on that is not in your question.
Apr
22
comment Postgres 9.3: How to update row that has max value of a timestamp in addition to other selection criteria?
@Fawn: This one is a sub-select, which always requires parentheses. The INSERT statement accepts a query as source in standard syntax. If in doubt, consult the SQL command reference‌​.
Apr
22
revised Inner join on array column in Postgres
trim noise, add tag
Apr
22
comment Inner join on array column in Postgres
WHERE attrelid = 'test_table'::regclass will do, since regclass already is an oid alias. A special one.
Apr
22
comment Anything like a hash for Postgresql databases?
So you can get false negatives, but no false positives. If diff does not report differences, you are safe. Else you have to investigate further.
Apr
22
revised Can I select data inserted in the same uncommited transaction?
added 26 characters in body
Apr
22
revised Can I select data inserted in the same uncommited transaction?
explain, add links
Apr
22
revised Can I select data inserted in the same uncommited transaction?
added 633 characters in body
Apr
22
answered Can I select data inserted in the same uncommited transaction?
Apr
21
revised Can this UPDATE be faster with indexes?
update explanation per comment
Apr
21
comment Can this UPDATE be faster with indexes?
@a_horse_with_no_name: Good point. I fixed that in passing without noting how deep the rabbit hole went ..
Apr
21
revised Can this UPDATE be faster with indexes?
format, trim noise, fitting title
Apr
21
comment Combine multiple queries into 1 query
What is the mean length of elements in words? How many elements on average in words? How many unique elements in your search? You mentioned 1000 combinations? That would be ~ 45 distinct words in one search? You can probably make this (substantially) faster, but it will take some time to find 1000 combinations in a million arrays. the fiddles don't seem to work (the site may have problems), please include the query to work with in your question.
Apr
21
comment Performance hickups after Postgres 9.4 upgrade
Interesting. I wouldn't have guessed.
Apr
21
revised The cost of left out join versus a select
clarify
Apr
20
answered The cost of left out join versus a select
Apr
20
comment Combine multiple queries into 1 query
@ZhaohanWeng: Almost all the time is spent on a CTE scan, which should not happen. Also, there are predicates you did not mention, yet. I don't think we have the full picture, yet. Can you add the exact query you are running in your question?
Apr
20
awarded  Copy Editor
Apr
20
comment Combine multiple queries into 1 query
@ZhaohanWeng: There may be a type mismatch. Are search terms and column exactly the same data type?
Apr
20
revised Combine multiple queries into 1 query
clean up