Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org> writes:
> Interestingly the planner statistics for this query are the same on the
> master and replica databases.
> However, query execution on the master database is about 4min. and on
> the replica database is 6 sec.!
What does EXPLAIN ANALYZE show in each case?
regards, tom lane
In response to
- slow query at 2003-02-21 16:30:53 from Oleg Lebedev
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2003-02-22 02:24:39|
|Subject: Re: Really bad insert performance: what did I do wrong? |
|Previous:||From: Kevin White||Date: 2003-02-21 19:18:12|
|Subject: Re: Really bad insert performance: what did I do wrong?|