On Tue, Oct 19, 2010 at 2:21 PM, Ozer, Pam po...@automotive.com wrote:
I have the following query running on 8.4, which takes 3516 ms. It is very
straight forward. It brings back 116412 records. The explain only takes
1348ms
select VehicleUsed.VehicleUsedId as VehicleUsedId ,
On Thu, Oct 28, 2010 at 10:39 AM, Robert Haas robertmh...@gmail.com wrote:
Can someone tell me why after it runs the index scan it hen runs a bitmap
heap scan? It should not take this long to run should it? If I limit the
results it comes back in 300ms.
It doesn't. The EXPLAIN output shows
On Tue, Oct 19, 2010 at 6:05 PM, Ozer, Pam po...@automotive.com wrote:
On mysql the same query only takes milliseconds not seconds. That's a
big difference.
I can believe that MySQL is faster, because they probably don't need
to do the bitmap heap scan. There is a much-anticipated feature
On 10/28/2010 10:42 AM, Robert Haas wrote:
I can believe that MySQL is faster, because they probably don't need
to do the bitmap heap scan. There is a much-anticipated feature
called index-only scans that we don't have yet in PG, which would help
cases like this a great deal.
Yyesss! Any time
On Thu, Oct 28, 2010 at 7:51 AM, Mladen Gogala
mladen.gog...@vmsinfo.com wrote:
Yyesss! Any time frame on that? Can you make it into 9.0.2?
Maybe 9.1.0 or 9.2.0 :) 9.0's features are already frozen.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
On 10/28/2010 10:53 AM, Richard Broersma wrote:
On Thu, Oct 28, 2010 at 7:51 AM, Mladen Gogala
mladen.gog...@vmsinfo.com wrote:
Yyesss! Any time frame on that? Can you make it into 9.0.2?
Maybe 9.1.0 or 9.2.0 :) 9.0's features are already frozen.
Well, with all this global warming around
On Thu, Oct 28, 2010 at 11:23 AM, Mladen Gogala
mladen.gog...@vmsinfo.com wrote:
On 10/28/2010 10:53 AM, Richard Broersma wrote:
On Thu, Oct 28, 2010 at 7:51 AM, Mladen Gogala
mladen.gog...@vmsinfo.com wrote:
Yyesss! Any time frame on that? Can you make it into 9.0.2?
Maybe 9.1.0 or 9.2.0
Ozer, Pam po...@automotive.com wrote:
I have the following query running on 8.4, which takes 3516 ms.
It is very straight forward. It brings back 116412 records. The
explain only takes 1348ms
The EXPLAIN ANALYZE doesn't have to return 116412 rows to the
client. It doesn't seem too out
On Tue, Oct 19, 2010 at 8:21 PM, Ozer, Pam po...@automotive.com wrote:
I have the following query running on 8.4, which takes 3516 ms. It is very
straight forward. It brings back 116412 records. The explain only takes
1348ms
Sort (cost=104491.48..105656.24 rows=116476 width=41) (actual
On mysql the same query only takes milliseconds not seconds. That's a
big difference.
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Tuesday, October 19, 2010 1:59 PM
To: Ozer, Pam; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Slow Query
10 matches
Mail list logo