Hi,
now I have an example and a query plan for 8.4 and 9.0.4. See the
differences! Performance with 9 is horrible.
I've eliminated the NOT-IN-Statements hoping it would be better, but this
had no effect.
Statement:
select kd.datum, kd.filiale, kd.kundart as segment, mis.shore(swiftlcd),
sum(coal
Alright, I've misunderstood this issue. Do you have to escape bytea columns
during export or import? And how you would do this?
Ty
2011/5/24 Craig Ringer
> On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote:
> > We had trbls with our drupal site, because some settings are stored in
> bytea c
Hi,
found the problem.
238 sec. with set enable_material = 'on'
4(!) sec. with set enable_material = 'off'
@Robert Haas: I thought it would be interesting to you, because
you've committed a patch regarding materialization for 9.0. If you like to
investigate this further, I can provide you more
I trying to get the next one :
pg_dump -h 192.170.1.3 -U User --format custom --inserts --verbose --file
\"/root/Desktop/$name .backup\" --table "$ESQUEMA.$Nametable" DB"
my Name table is detalle_Inegra , and the problem is that it table alwals
sent me a message like i COULD NOT FIND THE NAME
sorry I cound finish my problem.
I trying to get the next one :
pg_dump -h 192.170.1.3 -U User --format custom --inserts --verbose --file
\"/root/Desktop/$name .backup\" --table "$ESQUEMA.$Nametable" DB"
my Name table is detalle_Inegra , and the problem is that it table alwals
sent me a messa
That's strange...
If I comment out these rows
--sum(coalesce(e.num_wert,0)),
--sum(coalesce(d.num_wert,0))
in the given statement, it works fine with enable_material = 'on'.
I didn't change any join.
other settings are unchanged.
HashAggregate (cost=589873.86..593205.21 rows=12114 width=47) (act
On 24/05/11 18:58, Jasmin Dizdarevic wrote:
> Alright, I've misunderstood this issue. Do you have to escape bytea
> columns during export or import? And how you would do this?
Some database drivers and some apps don't understand the new hex output
format for bytea columns.
IIRC, the format change
On 25/05/11 03:26, manuel antonio ochoa wrote:
> sorry I cound finish my problem.
>
> I trying to get the next one :
>
> pg_dump -h 192.170.1.3 -U User --format custom --inserts --verbose
> --file \"/root/Desktop/$name .backup\" --table "$ESQUEMA.$Nametable" DB"
>
> my Name table is detalle_I
