Hi Aryan
when responding, please include the list as recipient too, so others have a
chance to help you.
W dniu 2012-09-08 08:00, Aryan Ariel Rodriguez Chalas pisze:
I didn't understand this part:
so change connection mode when running the application _at remote_ site
_locally_ to the
Hello Community,
I intend to understand further on PostgreSQL Index behavior on a SELECT
statement.
We have a situation where-in Index on unique column is not being picked up
as expected when used with-in the WHERE clause with other non-unique
columns using AND operator.
explain SELECT
Hi All
I´ve ft_simple_core_content_content_idx
ON core_content
USING gin
(to_tsvector('simple'::regconfig, content) );
If I´m seaching for a word which is NOT in the column content the query plan
and the execution time differs with the given limit.
If I choose 3927 or any higher
Hi,
I want to force deafults, and wonder about the performance.
The trigger i use (below) makes the query (also below) take 45% more time.
The result is the same now, but i do have a use for using the trigger (see
background info).
Isn't there a more efficient way to force the defaults (in the
On Mon, Sep 10, 2012 at 5:39 AM, Venkat Balaji venkat.bal...@verse.in wrote:
Hello Community,
I intend to understand further on PostgreSQL Index behavior on a SELECT
statement.
We have a situation where-in Index on unique column is not being picked up
as expected when used with-in the WHERE
On 10/09/12 16:24, bill_mar...@freenet.de wrote:
Hi All
I´ve ft_simple_core_content_content_idx
ON core_content
USING gin
(to_tsvector('simple'::regconfig, content) );
If I´m seaching for a word which is NOT in the column content the
query plan and the execution time differs with the
On 08/24/2012 05:47 AM, Felix Schubert wrote:
Hello List,
I've got a system on a customers location which has a XEON E5504 @
2.00GHz Processor (HP Proliant)
It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram:
The Postgres Performance on this system measured with pgbench