Stephan Szabo wrote:
On Wed, 27 Aug 2003, Michael Guerin wrote:
I'm running into some performance problems trying to execute simple
queries.
postgresql version 7.3.3
.conf params changed from defaults.
shared_buffers = 64000
sort_mem = 64000
fsync = false
effective_cache_size = 40
ex.
On 28 Aug 2003 at 10:38, Michael Guerin wrote:
IN(subquery) is known to run poorly in 7.3.x and earlier. 7.4 is
generally much better (for reasonably sized subqueries) but in earlier
versions you'll probably want to convert into an EXISTS or join form.
Something else seems to be going on,
On Thu, 28 Aug 2003, Michael Guerin wrote:
Stephan Szabo wrote:
On Wed, 27 Aug 2003, Michael Guerin wrote:
I'm running into some performance problems trying to execute simple
queries.
postgresql version 7.3.3
.conf params changed from defaults.
shared_buffers = 64000
sort_mem =
Stephan Szabo wrote:
On Thu, 28 Aug 2003, Michael Guerin wrote:
Stephan Szabo wrote:
On Wed, 27 Aug 2003, Michael Guerin wrote:
I'm running into some performance problems trying to execute simple
queries.
postgresql version 7.3.3
.conf params changed from defaults.
On Thu, 28 Aug 2003, Michael Guerin wrote:
Stephan Szabo wrote:
On Thu, 28 Aug 2003, Michael Guerin wrote:
Stephan Szabo wrote:
On Wed, 27 Aug 2003, Michael Guerin wrote:
I'm running into some performance problems trying to execute simple
queries.
postgresql
Stephan Szabo wrote:
On Thu, 28 Aug 2003, Michael Guerin wrote:
Stephan Szabo wrote:
On Thu, 28 Aug 2003, Michael Guerin wrote:
Stephan Szabo wrote:
On Wed, 27 Aug 2003, Michael Guerin wrote:
I'm running into some performance problems trying to