Re: [HACKERS] A bad plan

2005-03-13 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Josh Berkus wrote: Gaetano, Hi all, running a 7.4.5 engine, I'm facing this bad plan: Please take this to the PGSQL-PERFORMANCE mailing list; that's what that list exists for. Or IRC, where I know your are sometimes. But not -Hackers.

[HACKERS] A bad plan

2005-03-07 Thread Gaetano Mendola
Hi all, running a 7.4.5 engine, I'm facing this bad plan: empdb=# explain analyze SELECT name,url,descr,request_status,url_status,size_mb,estimated_start,request_time_stamp empdb-#FROM v_sc_user_request empdb-#WHERE empdb-# login =

Re: [HACKERS] A bad plan

2005-03-07 Thread Josh Berkus
Gaetano, Hi all, running a 7.4.5 engine, I'm facing this bad plan: Please take this to the PGSQL-PERFORMANCE mailing list; that's what that list exists for. Or IRC, where I know your are sometimes. But not -Hackers. Thanks! -- Josh Berkus Aglio Database Solutions San Francisco