Database Administrators Meta
to customize your list.
more stack exchange communities
Start here for a quick overview of the site
Detailed answers to any questions you might have
Discuss the workings and policies of this site
PostgreSQL 8.3: Slow GROUP BY on large table
I have a table with about 10 million records. I want to do a simple group by, but it's using a sequential scan and is slow... select run_id, count(*) from result group by run_id; I have an index ...
Jan 28 '13 at 16:05
newest postgresql-8.3 group-by questions feed
Hot Network Questions
mastermind horse battery staple
Realizing algebraic curves as complete intersections
Exactly how secret was the reveal in The Empire Strikes Back?
My authority over private airspace
Using funny error messages in Finance
Idiom for "just because you give something a different name, it doesn't change what it is"
Why is salary inversion a problem?
How to calculate the square root of a feature attribute?
If a program terminates and there is no one to see it, does it halt?
Why should I sign data that's already encrypted?
Top-down hamburger menu / is it a cool experience regarding my application?
Is CMYK less blue than sRGB?
Health insurance for PhD students in US?
Prior art for US patent application 20140196008 'IMMUTABLE OBJECT TYPES '
Why can't I `tail -f /proc/$pid/fd/1`?
Is ~ considered like a relative path?
Does defeating the flagship in the rebel stronghold sector counts to unlock new ships?
What does “bupke” mean?
Efficiency with strcpy, strcat and malloc
Who is this black haired girl with two large swords?
Generate random numbers without repetitions
Why isn't a SOQL query of mine populating a list in an Apex test class?
What specifically does expressive power refer to?
A word for 'the ability to see beauty'
more hot questions
Life / Arts
Culture / Recreation
TeX - LaTeX
Unix & Linux
Ask Different (Apple)
Geographic Information Systems
Science Fiction & Fantasy
Seasoned Advice (cooking)
Personal Finance & Money
English Language & Usage
Mi Yodeya (Judaism)
Cross Validated (stats)
Theoretical Computer Science
Meta Stack Exchange
Stack Overflow Careers
site design / logo © 2014 stack exchange inc; user contributions licensed under
cc by-sa 3.0