Re: [PERFORM] Check Pointer

itishree sukla wrote: > itishree sukla wrote: >> Heikki Linnakangas wrote: >>> itishree sukla wrote: >>> In our server Check pointer process is consuming 8 GB of memory, what could be the possible reason? Can any one please help. >>> >>> Are you sure you're measuring the memory co

Re: [PERFORM] Not same plan between static and prepared query

On Thursday, June 06, 2013 1:56 PM Ghislain ROUVIGNAC wrote: > Hello, > We have a strange issue related to a prepared statement. > We have two equals queries where the sole difference is in the limit. > - The first is hard coded with limit 500. > - The second is prepared with limit $1 ($1 is b

[PERFORM] Not same plan between static and prepared query

Hello, We have a strange issue related to a prepared statement. We have two equals queries where the sole difference is in the limit. - The first is hard coded with limit 500. - The second is prepared with limit $1 ($1 is bound to 500). PostgreSQL give us two different plans with a huge execu