Re: [ADMIN] How to uses self query plan

2007-12-19 Thread Scott Marlowe
On Dec 19, 2007 5:17 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Guillaume Lelarge a écrit : > > [EMAIL PROTECTED] wrote: > > > >> You're right . > >> I will begin by migrate postgresql version. > >> postgresql is now to 8.3 version . A lot of performance inprovements > >> have been made in

Re: [ADMIN] How to uses self query plan

2007-12-19 Thread [EMAIL PROTECTED]
Guillaume Lelarge a écrit : [EMAIL PROTECTED] wrote: You're right . I will begin by migrate postgresql version. postgresql is now to 8.3 version . A lot of performance inprovements have been made in this last version . In any case I must do a pg_dump/pg_restore. So , Should I try directly 8.3

Re: [ADMIN] How to uses self query plan

2007-12-19 Thread Scott Marlowe
On Dec 19, 2007 4:23 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > You're right . > I will begin by migrate postgresql version. > postgresql is now to 8.3 version . A lot of performance inprovements > have been made in this last version . > In any case I must do a pg_dump/pg_restore. > So , Sh

Re: [ADMIN] How to uses self query plan

2007-12-19 Thread Guillaume Lelarge
[EMAIL PROTECTED] wrote: > You're right . > I will begin by migrate postgresql version. > postgresql is now to 8.3 version . A lot of performance inprovements > have been made in this last version . > In any case I must do a pg_dump/pg_restore. > So , Should I try directly 8.3 version or is it more

Re: [ADMIN] How to uses self query plan

2007-12-19 Thread [EMAIL PROTECTED]
You're right . I will begin by migrate postgresql version. postgresql is now to 8.3 version . A lot of performance inprovements have been made in this last version . In any case I must do a pg_dump/pg_restore. So , Should I try directly 8.3 version or is it more cautious to stay in 8.1.x versio

Re: [ADMIN] How to uses self query plan

2007-12-19 Thread Scott Marlowe
On Dec 19, 2007 1:57 AM, olivier boissard <[EMAIL PROTECTED]> wrote: > Scott Marlowe a écrit : > > > On Dec 18, 2007 4:21 PM, [EMAIL PROTECTED] > > <[EMAIL PROTECTED]> wrote: > > > >> Hello, > >> > >> My purpose is to uses different query plan depending on queries > >> I got the following problem :

Re: [ADMIN] How to uses self query plan

2007-12-18 Thread olivier boissard
Scott Marlowe a écrit : On Dec 18, 2007 4:21 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, My purpose is to uses different query plan depending on queries I got the following problem : some queries are taking too much time and postgresql does not take the most relevant index in acc

Re: [ADMIN] How to uses self query plan

2007-12-18 Thread Scott Marlowe
On Dec 18, 2007 4:21 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, > > My purpose is to uses different query plan depending on queries > I got the following problem : some queries are taking too much time and > postgresql does not take the most relevant index in account. > I search on i

[ADMIN] How to uses self query plan

2007-12-18 Thread [EMAIL PROTECTED]
Hello, My purpose is to uses different query plan depending on queries I got the following problem : some queries are taking too much time and postgresql does not take the most relevant index in account. I search on internet and found that no HINT function was available in postgresl. I tried to