Hello,
On Thu, Feb 9, 2012 at 9:12 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Feb 8, 2012 at 2:01 PM, <petr.jediny@gmail.com> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 6444
>> Logged by: Petr Jediný
>> Email address: petr.jediny@gmail.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