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 query-performance questions feed
Hot Network Questions
Why do the engines seem to power down and then back up after take-off?
Why is the pressure inside a soap bubble higher than outside?
More emphatic term for "Expert"?
How to decide what type of paper to use for a flyer to hand out at a tradeshow?
What Ray Bradbury story contains the line
Word a male can use to refer to a female that is not old or young (girl/lady/woman)
Should a Landing Page tell the User how to Pronounce the Company's Name?
Why a string which contains '\0' and '\t' can't use operator == to compare with "\0\t"?
'modern' browser that will work in windows 98SE
Which is faster: while(1) or while(2)?
Need Help for Salesforce SOQL for Get Record in Date Range
File sizes in Windows not making sense
How do pilots manage to keep aircraft on white line during taxi
Checking conditions before allowing a play button to become visible
How to iterate through multiple file extension without caring about case sensitivity?
Where can I find this iPad mini wallpaper used in Apple's advert?
What is a good analogy to explain to a layman why passwords should be hashed?
Proof of an inequality
Contrary of "As its/their name indicates"
How important is Sanskrit?
Why is there a saving throw for each ability score?
RAID-5: Two disks failed simultaneously?
Did Qui Gon know the Queen was a double?
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