Hi!
I'm testing an update on 66k rows on Postgresql, and it seems
something is not right here.
My server is a Quad-Xeon 3.2 Ghz with 2 GB RAM and a RAID 1 running
FreeBSD 6.3 and PgSQL 8.3. My development machine is a PowerBook G4
1.67 Ghz with 2 GB RAM, OS X Leopard and PgSQL 8.3.
Miguel Arroz <[EMAIL PROTECTED]> wrote ..
>I'm testing an update on 66k rows on Postgresql, and it seems
> something is not right here.
>
>My server is a Quad-Xeon 3.2 Ghz with 2 GB RAM and a RAID 1 running
> FreeBSD 6.3 and PgSQL 8.3. My development machine is a PowerBook G4
> 1.67 G
Miguel Arroz <[EMAIL PROTECTED]> writes:
> EXPLAIN ANALYZE UPDATE text_answer_mapping_ebt SET f1 = false;
> QUERY PLAN
> -
On Mon, 10 Mar 2008, Miguel Arroz wrote:
My question is, how can I "ask" PgSQL what's happening? How can I avoid
guessing, and be sure of what is causing this slowdown?
There are many pieces involved here, and any one or multiple of them could
be to blame. Someone may make a guess and get lu
