On Mon, Apr 5, 2010 at 23:45, John R Pierce wrote:
> Magnus Hagander wrote:
>>
>> No, there's a problem with the Desktop Heap getting exhausted because
>> of system DLLs that allocate from it whenever they are loaded into a
>> process. It's in the Windows FAQ on wiki.postgresql.org - IIRC it's
>>
Magnus Hagander wrote:
fwiw, on my win7 pro 64bit desktop, that reads...
%SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows
SharedSection=1024,20480,768
Windows=On SubSystemType=Windows ServerDll=basesrv,1
ServerDll=winsrv:UserServerDllInitialization,3
ServerDll=winsrv:ConSer
> I've got a similar problem in my 18th century research, when clerks usually
> took pride in being able to spell a name in any number of ways. I've landed on
> a solution where I'm sending search strings to SIMILAR TO. I usually get far
> too many hits, but it's much easier to browse through 100 h
Den 5 april 2010 11.57 skrev Magnus Hagander :
>> Note how the planner estimates that there are 766 rows in the table
>> that matches the word 'tagtext'. In reality 43374 does. I've tried to
>> get postgres to refresh the statistics by running with
>> enable_statistics_target=100, running VACUUM, V
2010/4/6 Björn Lindqvist
> Den 5 april 2010 11.57 skrev Magnus Hagander :
> >> Note how the planner estimates that there are 766 rows in the table
> >> that matches the word 'tagtext'. In reality 43374 does. I've tried to
> >> get postgres to refresh the statistics by running with
> >> enable_sta
Den 6 april 2010 14.22 skrev Scott Mead :
>
> 2010/4/6 Björn Lindqvist
>>
>> Den 5 april 2010 11.57 skrev Magnus Hagander :
>> >> Note how the planner estimates that there are 766 rows in the table
>> >> that matches the word 'tagtext'. In reality 43374 does. I've tried to
>> >> get postgres to re
On 4/5/2010 3:00 PM, Peter Geoghegan wrote:
http://www.postgresql.org/docs/8.4/static/fuzzystrmatch.html
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
Fuzzystrmatch is generally used to compare two single words for how
similar they sound. How can tha
On Mon, Apr 05, 2010 at 10:44:53PM -0400, Merlin Moncure wrote:
- On Mon, Apr 5, 2010 at 4:36 PM, David Kerr wrote:
- > On Sat, Apr 03, 2010 at 09:32:25PM -0400, Merlin Moncure wrote:
- > Based on a lot of the comments i've gotten here, I'm starting to think that
I've got the wrong idea about
- >
On Mon, Apr 05, 2010 at 09:46:45PM -0600, Scott Marlowe wrote:
- On Mon, Apr 5, 2010 at 2:36 PM, David Kerr wrote:
- > My app will have over 10k concurrent users. I have huge servers 32 cores
(64bit), 64GB ram. RedHat linux.
- >
- > Those 10k users will all be logging in as one of 5 application u
On Tue, Apr 6, 2010 at 1:09 PM, David Kerr wrote:
> On Mon, Apr 05, 2010 at 10:44:53PM -0400, Merlin Moncure wrote:
> - pgbouncer is totally transparent. I manage quite a few databases and
> - I use it (w/session mode) so I can psql to a single host (localhost),
> - and bounce between different d
On Mon, 2010-04-05 at 18:28 +0200, Gerhard Heift wrote:
> create type period as (
> since timestamptz,
> "until" timestamptz
> );
Please take a look at:
http://pgfoundry.org/projects/temporal
That may be a more useful type for you, and it's also called "PERIOD".
> with rows:
> + a gist inde
Hi
Last night i mailed a message about me not being able to install Postgresql
8.4.3 successfully on windows 7 professional.
I have since temporary quitted my antivirus and firewall programs and I
could install successfull.
In the installation it askes you for a password which it uses for for the
Hi,
I was trying to update certain columns in a table, but the update never took
place, but did not throw an exception. I investigated the code in the 'before
update' trigger, and put in some RAISE NOTICE statements. I could then see
that another update of the same table was happening, too, b
Susan Cassidy writes:
> Sequence of events when problem occurred:
> update table a
> causes update table b
> which updates table a again (different column)
> trigger for table b returns null
> update of table a does not happen
Different column of same row, you mean? Yes, I think that wou
On 6 Apr 2010, at 21:00, Heine Ferreira wrote:
> Hi
>
> Last night i mailed a message about me not being able to install Postgresql
> 8.4.3 successfully on windows 7 professional.
> I have since temporary quitted my antivirus and firewall programs and I could
> install successfull.
> In the ins
Hi all,
I'm trying to use a cursor returned by a function from another function. But
I can't seem to get it working correctly. The error message is:
ERROR: cursor FOR loop must use a bound cursor variable
I am not sure how to bind it;
my code is similar to this:
create or replace function sto
Nikhil G. Daddikar wrote:
>
>
> I have tried earlier versions of 8.4 installer on Vista x32 and they'd
> failed too. But let me try the latest installer again. I will let you know.
Any luck with the call? Or are we still at "it doesn't work on your
systems or some others but does on many, and w
On 07-04-2010 10:04, Craig Ringer wrote:
Nikhil G. Daddikar wrote:
I have tried earlier versions of 8.4 installer on Vista x32 and they'd
failed too. But let me try the latest installer again. I will let you know.
Any luck with the call? Or are we still at "it doesn't work on your
Hello
2010/4/7 Marc Menem :
> Hi all,
>
> I'm trying to use a cursor returned by a function from another function. But
> I can't seem to get it working correctly. The error message is:
> ERROR: cursor FOR loop must use a bound cursor variable
> I am not sure how to bind it;
you can't do it now
19 matches
Mail list logo
