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
"Whatever doesn't kill you, simply makes you stranger" - what does it mean?
Can I enter an enduro race on a hardtail mountain bike?
What's the probability that from 25 random numbers between 1 and 100, the highest appears more than once?
What happens if I throw a battery into water?
Why electronegativity difference greater than 1.7 are ionic?
Why do some websites enforce lack of SSL?
Ctrl+L in terminal
Could "prequel" be used as an adjective?
How do I check if a zero is positive or negative?
Reasons companies insist on presenting you with an offer in a face to face meeting?
How should I tell a coworker their headphones are too loud?
Acute angle routes in PCB
Is there a formal phrase for saying that the location of an event changes between two places?
Implementing undo and redo for an Array?
Optimizing boolean checking method
How do I get into the Jawa's Sandcrawler
Is a separate thread for game loop compulsory for simple games?
Best word for “computer science”
Harry Potter - Why do acts of "accidental" magic only seem to happen around Muggles?
Is it legal to land in bad visibility conditions without ILS?
In the movies, is Sauron's armor correctly portrayed?
In Battlefield 4, how do I know when I've been issued an order?
Item Creation Without Experience Points
Is there an anti pattern for historically grown software?
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 Overflow
Stack Overflow Careers
site design / logo © 2014 stack exchange inc; user contributions licensed under
cc by-sa 3.0