Re: [GENERAL] Slow query with join

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 - R&D Tél. 418 659-7272 ou 1 888 692-1050 www.j

Re: [GENERAL] Slow query with join

>-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 writes: >> On 16.3.2015 19:50, Ma

[GENERAL] Slow query with join

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

Re: [GENERAL] BAKUP ISSUE

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 mailto:rameshparnandit...@gmail.com>> wrote: Yes,not an error it is a warning and archive is wo

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

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

Re: [GENERAL] 32-bit libpq with 64-bit server

inger [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

[GENERAL] 32-bit libpq with 64-bit server

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 libp

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

it - use /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 Sc

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

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! That

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

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

[GENERAL] Postgres 9.2 beta2 one-click installer on windows

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