PROTECTED]
Sent: Wednesday, October 01, 2003 2:51 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] FreeSpaceMap hashtable out of memory
"Maksim Likharev" <[EMAIL PROTECTED]> writes:
> Using PG under Cygwin we having following error message during INSERT
>
Hi,
Using PG under Cygwin we having following error message during INSERT
INTO
"FreeSpaceMap hashtable out of memory".
What does that mean?
And if for a moment step out of knowledge 'PG under Cygwin', what in
general
this message is about and more important how to fix it?
Thank you.
---
Just want to add my $0.03 on that.
single file DB has some benefits as:
1. ability to allocate one continues chunk on disk,
significantly reduces disk seeks,
mostly ancestral but still true today ( I still see DB living on none
arrays )
2. And of cause countless design considerations.
Say
Possible, but if before almost every tenth query crash the server
now it stays, that's only I care about.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 2:05 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [HA
, NO WARRANTY, NO NOTHING, just for you information.
Regards.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
&qu
I would referrer dump that gar.xxg, and put PG on Linux,
but this is not up to me.
Thanks for the help.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG
m on SunOS 5.8,
BTW on Linux it works
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:45 AM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
"Maksim Likharev
mlen + 1);
}
pfree(val);
val = xfrmstr;
}
-Original Message-
From: Maksim Likharev
Sent: Tuesday, July 08, 2003 9:35 AM
To: 'Tom Lane'
Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] PG crash on simple query, story continues
()
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:14 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG crash on simple query, story continues
"Maksim Likharev" <[EMAIL PROTECTED]> writes:
> SELECT p.docid FR
Hi,
I have interesting question that stops me now.
Suppose I have 2 functions
1. preparestate
2. doajob
first allocates some state using
MemoryContextAlloc(TopTransactionContext)
or something, another function using that memory.
question is how I lookup that memory in second function doajob?
function call, would be much helpful in such case.
In comparison with Microsoft SQL, productivity of using
profiling/debugging tools sorry to say that, far behind.
-Original Message-
From: Karel Zak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 1:04 AM
To: Maksim Likharev
Cc
Hi,
I have some SQL function, just regular function selects data by using 4
joins nothing fancy,
but one thing pretty noticeable,
I have to display 3 different columns with same date formatted
differently,
here are 3 different snippets:
1. SELECT t.x,t.y,TO_CHAR(t.dt, 'DD/MM/')
FROM
Hi,
could somebody explain me please why following select
SELECT docid FROM prod.guids
GROUP BY docid HAVING( COUNT(docid) > 1 )
taking 15 min on 2 Proc Box on 1M rows, where number of duplicates
around 300K,
and docid indexed and not null and char(16).
May be I am doing something wrong?
13 matches
Mail list logo
