Skip site navigation (1) Skip section navigation (2)

Re: BUG #6444: Postgresql crash

From: Petr Jediný <petr(dot)jediny(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6444: Postgresql crash
Date: 2012-02-09 20:26:54
Message-ID: CAD=W4J-RzKbyAxvQhO=k_eahxjt87W_rGpwMLpTSMZsZZcvWFA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello,

On Thu, Feb 9, 2012 at 9:12 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Feb 8, 2012 at 2:01 PM,  <petr(dot)jediny(at)gmail(dot)com> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference:      6444
>> Logged by:          Petr Jediný
>> Email address:      petr(dot)jediny(at)gmail(dot)com
>> PostgreSQL version: 8.4.10
>> Operating system:   Debian 6 Squeeze, 64bit
>> Description:
>>
>> Postgresql-8.4.9 (from debian squeeze repositories) works ok, after latest
>> debian update to 8.4.10 keeps crashing (oom kill) while working with large
>> tables/long running queries.
>
> Are you by any chance using the inet or cidr datatypes extensively?
>

Yes, you are right, we use network datatypes very extensively. We are
storing arp tables and dhcp acks etc.

> If not, can we see the table definitions and the queries?
>

If it's still needed I can provide the table dump, it's about 543M gziped.

Thank you,

Petr

> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company

In response to

Responses

pgsql-bugs by date

Next:From: Euler Taveira de OliveiraDate: 2012-02-09 22:14:55
Subject: Re: BUG #6444: Postgresql crash
Previous:From: Robert HaasDate: 2012-02-09 20:12:19
Subject: Re: BUG #6444: Postgresql crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group