Re: [GENERAL] weird behaviour

2001-08-30 Thread matthieuclavier
sorry, i forgot some version number :) [mat@biniac ~]$ psql --version psql (PostgreSQL) 7.1.2 contains readline, history support Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group Portions Copyright (c) 1996 Regents of the University of California Read the file COPYRIGHT or

[GENERAL] weird behaviour

2001-08-30 Thread matthieuclavier
hi, i'm notice a weird behaviour while running a query on the same table, the query take a long time to be executed when this table is empty , and when this table isn't empty, it take about 1/2 second the two tables are freshly vacuumed ... here the same tables, one is empty, not the other

[GENERAL] memory problems with freebsd

2001-07-26 Thread matthieuclavier
Hi, we work with PostgreSQL 7.0.3 and FreeBSD (4.2 / 4.3). the database is in production state, and daily heavy loaded. i think our problems are similar to problems described in : http://fts.postgresql.org/db/mw/msg.html?mid=28871 recently, we have updated our kernel, according to this doc :