Tue, 3 Mar 2009 18:37:42 -0700 -n
Scott Marlowe írta:
> Oh my lord, that is a foot gun waiting to go off. Assuming 2k
> connections, and somehow a fair number of them went active with big
I absolutely agree with Scott. Plus set effective_cache_size
accordingly, this would help the planner. You
Thu, 26 Feb 2009 09:00:07 +0100 -n
Claus Guttesen írta:
> > The execution time has not improved. I am going to increase the
> > shared_buffers now keeping the work_mem same.
>
> Have you performed a vacuum analyze?
>
and reindex
--
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabr...@i-logic.hu|
Wed, 25 Feb 2009 15:43:49 -0600 -n
Farhan Husain írta:
OK, you have two options:
1. Learn to read carefully, and differentiate between work_mem and
shared_buffers options. Lower work_mem and rise shared_buffers as
others wrote.
2. Leave Postgresql alone and go for Oracle or Microsoft SQL...
Rgd
(now that my test went through, here is the question :) )
Dear Community,
We are using PostgreSQL proudly for quite a long time, but now we are
facing an interesting problem. Query plan seems to depend on how long
the IN() clause is.
explain analyze
select p.product_id
from product p left join
sorry, I just wonder why I can't get my message delivered...
--
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabr...@i-logic.hu|Web: http://www.i-logic.hu=-
-=Tel/fax:+3612391618|Mobil:+36209278894 =-
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
