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
columns. I think lobs are a problem too, but pls see the pg_dump docs for
details.
Is it possible that you are referring to the `bytea_output' setting in
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),
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 cr...@postnewspapers.com.au
On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote:
We had trbls with our drupal site, because some
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
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 message
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)
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_Inegra , and