See, its calculating sum by grouping the product field. Here is an example
Product GP
- ---
A 30
B 40
A 30
C 50
C 50
Now the query calculates aggregated sum and divide by grouping product so
Analyzing did not help, here is the out of EXPLAIN ANALYZE of update query
Seq Scan on dummy (cost=0.00..56739774.24 rows=23441 width=275) (actual
time=18.927..577929.014 rows=22712 loops=1)
SubPlan
- Aggregate (cost=2420.41..2420.43 rows=1 width=19) (actual time=
25.423..25.425 rows=1
Scott Marlowe schrieb:
On Feb 11, 2008 12:08 PM, Thomas Zaksek [EMAIL PROTECTED] wrote:
I have serious performance problems with the following type of queries:
/
/explain analyse SELECT '12.11.2007 18:04:00 UTC' AS zeit,
'M' AS datatyp,
p.zs_nr
I have serious performance problems with the following type of queries:
Doesnt looks too bad to me, but i'm not that deep into sql query
optimization. However, these type of query is used in a function to
access a normalized, partitioned database, so better performance in this
queries would
Stephen Denne [EMAIL PROTECTED] writes:
Pallav Kalva asked
...
and listing0_.fklistingsourceid=5525
...
order by listing0_.entrydate desc limit 10;
- Index Scan Backward using idx_listing_entrydate on
listing listing0_ (cost=0.00..781557.28 rows=5118 width=107) (actual
Pallav Kalva asked
...
and listing0_.fklistingsourceid=5525
...
order by listing0_.entrydate desc limit 10;
- Index Scan Backward using idx_listing_entrydate on
listing listing0_ (cost=0.00..781557.28 rows=5118 width=107) (actual
time=2113544.412..2113544.412 rows=0
Hi,
I am using Postgres 8.2.4, we have to regularly run some queries on
some big tables to see if we have any data for a particular request. But
sometimes we might not have any matching rows on a particular request as
in this case, when it cant find any matching rows it pretty much scans
On Tue, 12 Feb 2008, Craig James wrote:
Does anyone have performance info about the new Dell Perc/6 controllers? I
found a long discussion (Dell vs HP) about the Perc/5, but nothing about
Perc/6. What's under the covers?
The Perc/6i has an LSI Logic MegaRAID SAS 1078 chipset under the
On 2008-02-12 13:35, Pallav Kalva wrote:
Hi,
...
Table Definitions
\d listing.listingstatus
Table listing.listingstatus
Column |Type
| Modifiers
Does anyone have performance info about the new Dell Perc/6 controllers? I found a long
discussion (Dell vs HP) about the Perc/5, but nothing about Perc/6. What's
under the covers?
Here is the (abbreviated) info from Dell on this machine:
PowerEdge 1950 IIIQuad Core Intel® Xeon®
On 2/11/08, Tom Lane [EMAIL PROTECTED] wrote:
Chris Kratz [EMAIL PROTECTED] writes:
- Nested Loop (cost=42.74..161.76 rows=1 width=38) (actual
time=2.932..27.772 rows=20153 loops=1)
- Hash Join (cost=10.89..22.58 rows=1 width=24) (actual
time=0.065..0.134 rows=1 loops=1)
On 2/11/08, Tom Lane [EMAIL PROTECTED] wrote:
Chris Kratz [EMAIL PROTECTED] writes:
- Nested Loop (cost=42.74..161.76 rows=1 width=38) (actual
time=2.932..27.772 rows=20153 loops=1)
- Hash Join (cost=10.89..22.58 rows=1 width=24) (actual
time=0.065..0.134 rows=1 loops=1)
Linux Guru [EMAIL PROTECTED] writes:
Analyzing did not help, here is the out of EXPLAIN ANALYZE of update query
Seq Scan on dummy (cost=0.00..56739774.24 rows=23441 width=275) (actual
time=18.927..577929.014 rows=22712 loops=1)
SubPlan
- Aggregate (cost=2420.41..2420.43 rows=1
Thanks Michael...
2008/2/11, Michael Fuhr [EMAIL PROTECTED]:
On Mon, Feb 11, 2008 at 05:37:51PM -0700, Michael Fuhr wrote:
On Mon, Feb 11, 2008 at 04:58:35PM -0700, fabrix peñuelas wrote:
If ssl is enable in postgresql decreanse the performance of the
database?
How much?
The
14 matches
Mail list logo