> On 15.03.2011 17:24, Merlin Moncure wrote:
>>
>>
>> well, regardless of the version, you're doing a gazillion sequential
>> scans on relation tags. This looks like the primary culprit (I had to
>> look up the ~~* operator...it's 'ilike'):
>> (
>> (k ~~* 'boundary'::text) OR
>> (
>> (k ~~
I know the intensity of ilikes but I don't see another way to solve it.
But that shouldn't be the problem because the query runs on another
server (not as powerful as the actual machine) with postgres 8.3 in
acceptable time (same data, same query).
Each of the collumns of the relation table has a
On Mon, Mar 14, 2011 at 9:48 AM, Jo wrote:
> I set the work_mem to 100MB and the shared buffers are 2 GB
>
> The query plans are long and complex. I send the beginning of the
> two plans. Hope this helps to understand the differences.
> I assume the join strategy in 8.3 differs from the one in 8.4
Hello,
that's the 8.4 query plan:
http://explain.depesz.com/s/dO7
The locale of the two databases is the same:
SHOW LC_COLLATE command gives the locale: "de_DE.UTF-8".
Regards,
Jo
On 14.03.2011 16:04, t...@fuzzy.cz wrote:
Hello
2011/3/14 Jo:
I set the work_mem to 100MB and the shar
>> we have performance problems running several queries pon postgres 8.4 .
>> Using the previous version (8.3) our queries performs well
>> (The queries are quite complex, consisting of several sub-queries and
>> various spatial functions).
Two things that frequently bite people during an upgrade:
> Hello
>
> 2011/3/14 Jo :
>> I set the work_mem to 100MB and the shared buffers are 2 GB
>>
>> The query plans are long and complex. I send the beginning of the
>> two plans. Hope this helps to understand the differences.
>> I assume the join strategy in 8.3 differs from the one in 8.4.
>>
>
> the
Hello
2011/3/14 Jo :
> I set the work_mem to 100MB and the shared buffers are 2 GB
>
> The query plans are long and complex. I send the beginning of the
> two plans. Hope this helps to understand the differences.
> I assume the join strategy in 8.3 differs from the one in 8.4.
>
these outputs are
I set the work_mem to 100MB and the shared buffers are 2 GB
The query plans are long and complex. I send the beginning of the
two plans. Hope this helps to understand the differences.
I assume the join strategy in 8.3 differs from the one in 8.4.
*
The beginn
Jo,
> we have performance problems running several queries pon postgres 8.4 .
> Using the previous version (8.3) our queries performs well
> (The queries are quite complex, consisting of several sub-queries and
> various spatial functions).
>
> Are there some major changes from 8.3 to 8.4 that ca
Hello,
we have performance problems running several queries pon postgres 8.4 .
Using the previous version (8.3) our queries performs well
(The queries are quite complex, consisting of several sub-queries and
various spatial functions).
Using a new server with debian squeeze and postgres 8.4 fr
10 matches
Mail list logo
