Update :
My query SELECT * FROM v_actor JOIN f_intervenant_ref ON (actor_id =
ir_actor_id) WHERE ir_dos_id = '5226' took 7 secs.
If I substitute the _RETURN rule for the view and add the above join, it takes
31 ms.
Mark Watson
Service au client - RD
Tél. 418 659-7272 ou 1 888 692-1050
-Message d'origine-
De : Tom Lane [mailto:t...@sss.pgh.pa.us]
Envoyé : March-16-15 5:07 PM
À : Tomas Vondra
Cc : pgsql-general@postgresql.org; Marc Watson
Objet : Re: [GENERAL] Slow query with join
Tomas Vondra tomas.von...@2ndquadrant.com writes:
On 16.3.2015 19:50, Marc Watson wrote
Hello all,
I am using PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 64-bit, as
downloaded from EnterpriseDB, and is running on my dev system under Win 7
64-bit.
I hope someone can help me with a problem I'm having when joining a view with a
table. The view is somewhat involved, but I can
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] De la part de hubert depesz
lubaczewski
Envoyé : July-09-14 9:55 AM
On Wed, Jul 9, 2014 at 3:28 PM, Ramesh T
rameshparnandit...@gmail.commailto:rameshparnandit...@gmail.com wrote:
Yes,not an error it is a
Original message:
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] De la part de Marc Watson
Envoyé : June-11-12 8:36 AM
À : Craig Ringer
Cc : pgsql-general@postgresql.org; dp...@pgadmin.org;
sachin.srivast...@enterprisedb.com
Objet : Re: [GENERAL] Postgres
[mailto:ring...@ringerc.id.au]
Envoyé : June-20-12 10:47 PM
On 06/20/2012 11:07 PM, Marc Watson wrote:
Hello all,
On Windows, I have a 32-bit client application that uses the 32-bit
libpq.dll. In testing the client application with a Postgres 9.2 64-bit server
I've noticed
Hello all,
On Windows, I have a 32-bit client application that uses the 32-bit
libpq.dll. In testing the client application with a Postgres 9.2 64-bit
server I've noticed no problems, and was wondering if anyone knows of
any caveats in this - AFAICS the tcp communication is between the 32-bit
/passive not /q when invoking it
- treat return 5100 as success
- swear at Microsoft for not documenting this
Continued below.
On 06/08/2012 11:55 PM, Marc Watson wrote:
Executing C:\Users\Mark
Watson\AppData\Local\Temp\postgresql_installer\vcredist_x64.exe /q
Script exit
Thanks, Craig
It was failing on vcredist_x86 and vcredist_x64, because I had newer versions
installed (10.0.40219). After uninstalling them, all is OK.
Mark Watson
De : Craig Ringer [mailto:ring...@ringerc.id.au]
Envoyé : June-08-12 1:35 AM
À : Marc Watson
Cc : pgsql-general@postgresql.org
De : Craig Ringer [mailto:ring...@ringerc.id.au]
Envoyé : June-08-12 9:20 AM
On 06/08/2012 08:04 PM, Marc Watson wrote:
Thanks, Craig
It was failing on vcredist_x86 and vcredist_x64, because I had newer versions
installed (10.0.40219). After uninstalling them, all is OK.
Oooh
Hi all,
Just a note that the 32 and 64-bit installers fail on windows 7 64-bit
with the error 'An error occurred executing the Microsoft VC++ runtime
installer.'. The beta-1 32-bit installer works OK.
- Mark Watson
11 matches
Mail list logo