Hello,
I could need some help.
I have a Postgresql
database When i do a query on my homeserver the result is given
back fast but when i do the same query on my webhost server the query is useless
because of the processtime (200 times slower
(56366.20 / 281.000 = 200.59) ). My Pc
is ju
I typed up a description of a situation where the only viable option to
improve performance was to use a materialized view, which, when implemented,
was found to improve performance twenty-sevenfold, even with a fairly small
amount of excess data (which is antipated to grow). I thought this mig
Andre Felipe Machado wrote:
It seems that Firebird windows can use adequately as much ram it finds
and postgresql windows can not.
PostgreSQL relies on the OS cache to utilize RAM. Make sure that most of
the RAM is 'available' so Windows can do its thing.
effective_cache_size should be set
On Thursday 09 March 2006 15:10, Tom Lane wrote:
> Is it possible to get a stack trace from the stuck process? I dunno
> if you've got anything gdb-equivalent under Windows, but that's the
> first thing I'd be interested in ...
Here ya go:
http://www.devisser-siderius.com/stack1.jpg
http://www.d
Javier Somoza wrote:
I wanna test my system performance when using pgCluster.
I'm using postgreSQL 8.1.0 and i've downloaded pgcluster-1.5.0rc7
and pgcluster-1.5.0rc7-patch.
Do i need to recompile postgreSQL with the patch?
Can i use pgcluster-1.5 with thi
> Is it possible to get a stack trace from the stuck process?
> I dunno if you've got anything gdb-equivalent under Windows,
> but that's the first thing I'd be interested in ...
Try Process Explorer from www.sysinternals.com.
//Magnus
---(end of broadcast)
On Thursday 09 March 2006 15:10, Tom Lane wrote:
> Jan de Visser <[EMAIL PROTECTED]> writes:
> > Furtermore, it does not happen on Linux machines, both single CPU and
> > dual CPU, nor on single CPU windows machines. We can only reproduce on a
> > dual CPU windows machine, and if we take one CPU ou
Jan de Visser <[EMAIL PROTECTED]> writes:
> Furtermore, it does not happen on Linux machines, both single CPU and dual
> CPU, nor on single CPU windows machines. We can only reproduce on a dual CPU
> windows machine, and if we take one CPU out, it does not happen.
> ...
> Which showed me that sev
I have more information on this issue.
First of, the problem now happens after about 1-2 hours, as opposed to the 6-8
I mentioned earlier. Yey for shorter test cycles.
Furtermore, it does not happen on Linux machines, both single CPU and dual
CPU, nor on single CPU windows machines. We can only
Title: RE: [PERFORM] pg_reset_stats + cache I/O %
Sorry I realized your fears :)
PostgreSQL is a new (last four months) install here and I'm responsible for it. Great DB and I enjoy working with it a lot and learning the nuances of it. Keep in mind that the management are 'old-time' system
I hope tomorrow execute explain with the bitmapscan and seqscan enabled.
bitmapscans are almost always faster?
Like all the rest, they're just a tool, which works great when used in
its intended purpose :
- Fetching just a few percent of the rows from a table is better served
by an in
Andre, Could not Postgresql file cache being killed by firebird activity?Haven´t you tried decrease ramdom_page_cost to 3 or 2?It would be better if only one person will make configuration changes, otherwise it will be difficult to measure each configuration change impact.ReimerAndre Felipe Mac
Hi all !
I wanna test my system performance when using pgCluster.
I'm using postgreSQL 8.1.0 and i've downloaded pgcluster-1.5.0rc7
and pgcluster-1.5.0rc7-patch.
Do i need to recompile postgreSQL with the patch?
Can i use pgcluster-1.5 with t
13 matches
Mail list logo
