Skip site navigation (1) Skip section navigation (2)

Re: slow query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow query
Date: 2003-02-22 02:20:39
Message-ID: 2050.1045880439@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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 LaneDate: 2003-02-22 02:24:39
Subject: Re: Really bad insert performance: what did I do wrong?
Previous:From: Kevin WhiteDate: 2003-02-21 19:18:12
Subject: Re: Really bad insert performance: what did I do wrong?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group