Hello pgsql-performance,
I discussed the whole subject for some time in DevShed and didn't
achieve much (as for results). I wonder if any of you guys can help
out:
http://forums.devshed.com/t136202/s.html
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROT
how my project
will run on PostgreSQL (Considering migration from MySQL).
I'll be reporting back on how the other stuff helped.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
Wednesday, April 28, 2004, 11:24:41 AM, you wrote:
MK> On Tue
(even if refreshing the page
would be really quick, sine Postgre already loaded the data to
memory).
P.S If the query or its EXPLAIN are critical for a better
understanding, let me know.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: Vit
around 2000.
As far as indexes are concerned, there's an index on all the rows
mentioned in the query (as can be seen from the explain), including
the vote_avg row.
Thanks and regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
Friday, May 21, 2
3.01 rows=1 width=76)
Index Cond: (bv_books.book_id = "outer".book_id)
Thank you for your try.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
Friday, May 21, 2004, 11:10:56
> iterations from 1993 to 10.
I'm afraid your idea is invalid in my case =\... Naturally I could
eventually do data coupling to gain perforemnce boost if this issue
will not be solved in other ways. I'll keep your idea in mind anyway,
thanks.
Once again thanks for you feedback.
Regar
> Seq Scan on bv_books (cost=0.00..4048.18 rows=171918
width=76) (actual time=0.000..359.000 rows=171918 loops=1)
Total runtime: 6734.000 ms
------
Regards,
Vitaly Belman
sidering using it
through VMWare. Do you think it would suffice as a comprasion?
From what I saw (e.g
http://usuarios.lycos.es/hernandp/articles/vpcvs.html) the performance
are bad only when it's coming to graphics, otherwise it looks pretty
good.
Regards,
Vitaly Belman
ICQ: 1912453
AI
e.com/
http://www.colinux.org/
Thanks to Bryan and Matthew for their advices regarding the emulations.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end of broadcast)---
TIP 8: explain analyze is your friend
ast() in Oracle
(IIRC)? I believe that in such cases MySQL does first() by itself.
Other ideas are welcome too.
Regards,
Vitaly Belman
ICQ: 1912453
AIM: VitalyB1984
MSN: [EMAIL PROTECTED]
Yahoo!: VitalyBe
---(end of broadcast)---
TIP 3: if
entually almost doubles the execution time.
On Sun, 13 Jun 2004 08:52:12 -0500, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
>
> On Sun, Jun 13, 2004 at 06:21:17 +0300,
> Vitaly Belman <[EMAIL PROTECTED]> wrote:
> >
> > Consider the following query:
> >
> >
Is it possible to download the Visual Explain only (link)? I only see
that you can donwload the whole ISO (which I hardly need).
On Thu, 17 Jun 2004 13:52:15 +0100, Paul Thomas <[EMAIL PROTECTED]> wrote:
>
>
> On 17/06/2004 12:10 Adam Witney wrote:
> >
> > Will this run on other platforms? OSX m
I see. Thanks :).
On Thu, 17 Jun 2004 18:35:11 +0100, Paul Thomas <[EMAIL PROTECTED]> wrote:
>
> On 17/06/2004 17:54 Vitaly Belman wrote:
> > Is it possible to download the Visual Explain only (link)? I only see
> > that you can donwload the whole ISO (which I hardly ne
I have a problem with certain queries performance. Trouble is that
while their execution plan is pretty good and mostly their execution
is great as well, their FIRST execution time (that is after you mount
the database) is abysmal.
I realize that it happens due to the loading of data from the HD t
Here's the query:
---
SELECT * FROM bv_reviews r, bv_votes v
WHERE r.vote_id = v.vote_id
AND v.book_id = 113
---
bv_votes has around 7000 rows with the
15 matches
Mail list logo
