Monday, December 12, 2011, 1:45:42 AM you wrote:
> Jochen, could you try the attached patch?
Patch is missing a variable define for 'r' in network_sup(). Fixed patch
attached.
Memory usage for insert ~1087MB - no change
Memory usage for index creation ~415MB - fixed.
Memory usage for select ~15
Andres Freund writes:
> In 3b8161723c645853021b57330dd2ea0484ec6131 Heikki made DatumGetInetP unpack
> toasted values. Unfortunately the btree support functions for the inet type
> didn't free memory which they have to do in contrast to about everything else.
> I fixed a few more functions than
Sorry about that, here is a script to demonstrate using a much simpler
example.
It presumes linux and that there is a bash shell at /bin/bash.
You should see table created and loaded (takes a few minutes), then
successful query explain and run,
then create index and re-run the explain (now
Hi,
On Monday, December 12, 2011 12:45:23 AM Andres Freund wrote:
> On Sunday, December 11, 2011 10:15:29 PM Jochen Erwied wrote:
> > The following script can be used to show the behaviour:
> >
> > create database pgtest;
> > \c pgtest
> > create table test(var inet);
> > insert into test(var) '1
Hi,
On Sunday, December 11, 2011 10:15:29 PM Jochen Erwied wrote:
> The following script can be used to show the behaviour:
>
> create database pgtest;
> \c pgtest
> create table test(var inet);
> insert into test(var) '127.0.0.0'::inet+generate_series(0,256*256*256-1);
> create index test_ix on
Hi
For Libpqwce. NET 2003 VB programming language should support
pgFOUNDRY the DLL in C, C + + programming language support.
Cihan ŞENGÜL
2011/12/11 Peter Geoghegan
> Libpqwce
Hi
Libpqwce are published. Gösterilemiyor.Bana reference to VB NET 2003. NET
2003, I can reference the DLL required for VB
Cihan ŞENGÜL
2011/12/10 Peter Geoghegan
> On 10 December 2011 15:13, Hiroshi Saito wrote:
> > First, official support does not have Postgrs about WinCE.
> >
> > Next, I
After upgrading from 9.1.1 to 9.1.2, memory usage for some queries
increased to the amount that the OOM-killer on Linux terminated the server.
Further investigation show the problem to occur under multiple circumstances:
- copying data from an external file into a table with indexes
- creating in
On 11 December 2011 17:53, Cihan ŞENGÜL wrote:
> Hi
> Libpqwce are published. Gösterilemiyor.Bana reference to VB NET 2003. NET
> 2003, I can reference the DLL required for VB
I don't understand.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
