Is
this a common issue among all RDBMSs or is it
something that is PostgreSQL specific?
Speaking from experience, this sort of thing affects MSSQL as well, although
the maintenance routines are different.
Yes, this is true with MSSQL too, however sql server implements a defrag
index
*statistics target = 100
*INFO: index timeseries_tsid now contains *16,677,521* row versions
in 145605 pages
DETAIL: 76109 index pages have been deleted, 2 are currently reusable.
CPU 12.00s/2.83u sec elapsed 171.26 sec.
INFO: timeseries: found 0 removable, 16677521 nonremovable row
Hi Tom,
I don't believe I did run Analyze, I was under the assumption that the
statistics would have been up to date when the indexes were created.
Thanks for the quick response.
-mike
Tom Lane wrote:
Michael Guerin [EMAIL PROTECTED] writes:
I just restored a database running
I just restored a database running on a solaris box to a linux box
and queries take forever to execute. The linux box is faster and has
twice the memory allocated to postgresql, is there anything obvious that
I should look at? It is using a journal file system.
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. query: select * from x where id in (select id from y);
There's an
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. query: select * from x where id in (select id from y);
There's an
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
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
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