people have seen this.
2. No solutions.
3. The server message appears to indicate an unhandled WSAEWOULDBLOCK winsock
error on recv(), which MSDN said is to be expected and should be retried.
Is this a known bug?
jan
--
--
Jan de
?
jan
On Monday 06 March 2006 09:38, Jan de Visser wrote:
Hello,
While doing performance tests on Windows Server 2003 we observed to
following two problems.
Environment: J2EE application running in JBoss application server, against
pgsql 8.1 database. Load is caused by a smallish number
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 out
Hagander for the Process Explorer hint.
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Friday 10 March 2006 09:03, Jan de Visser wrote:
On Friday 10 March 2006 04:20, Magnus Hagander 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
On Friday 10 March 2006 09:32, Jan de Visser wrote:
Actually, stack2 looks very interesting. Does it stay stuck in
pg_queue_signal? That's really not supposed to happen.
Yes it does.
An update on that: There is actually *two* processes in this state, both
hanging in pg_queue_signal
lock up within 5mins.
So I think they broke something.
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu
up a patch
that would be great.
As a BTW: I reinstalled SP1 and turned stats collection off. That also seems
to work, but is not really a solution since we want to use autovacuuming.
//Magnus
jan
--
--
Jan de Visser
On Friday 10 March 2006 14:27, Jan de Visser wrote:
As a BTW: I reinstalled SP1 and turned stats collection off. That also
seems to work, but is not really a solution since we want to use
autovacuuming.
I lied. I hangs now. Just takes a lot longer...
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
TIP 1: if posting/reading through
On Wednesday 15 March 2006 18:21, Simon Riggs wrote:
On Wed, 2006-03-15 at 14:39 -0500, Jan de Visser wrote:
After fixing the hanging problems I reported here earlier (by
uninstalling W2K3 SP1), I'm running into another weird one.
After doing a +/- 8hr cycle of updates and inserts (what
fixes but didn't find any.
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end
that was committed a couple of days ago?
No I haven't. Worth a test on a rainy afternoon I'd say...
//Magnus
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu
of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast
://www.clickspace.com
On May 31, 2006, at 6:34 AM, Jan de Visser wrote:
On Wednesday 31 May 2006 02:29, Brendan Duddridge wrote:
We'll probably have to write a process to update the click_count from
querying our product_click_history table.
How about an insert trigger on product_click_history which
if count = 10.
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast
the filesystem cache will gobble them up, which means indirectly
pgsql profits as well (assuming no other apps poison the fs cache).
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu
On 12/20/07, Tom Lane [EMAIL PROTECTED] wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
Well, I'm not even sure if those got applied or were just Tom hacking
in the basement or, heck, my fevered imagination. :)
For the record, I hack in the attic ... or what I tell the IRS is my
third-floor
On 5/14/08, Greg Smith [EMAIL PROTECTED] wrote:
On Wed, 14 May 2008, Alvaro Herrera wrote:
If neither of the bits is set, then the transaction is either in progress
(which you can check by examining the list of running transactions in shared
memory) or your process is the first one to check
On Thursday 15 May 2008 03:02:19 Tom Lane wrote:
Jan de Visser [EMAIL PROTECTED] writes:
Obviously, this issue is tied to the slow count(*) one, as I found out
the hard way. Consider the following scenario:
* Insert row
* Update that row a couple of times
* Rinse and repeat many times
On Monday 23 June 2008 07:06:54 bijayant kumar wrote:
Hello to list,
We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling
with postgresql performance. Any query say select * from tablename takes
10-15 mins to give the output, and while executing the query system loads
23 matches
Mail list logo