how can I get read of that - Mailing list pgsql-hackers

Hi all

First, many thanks to all who helped with my crashes probs. Not fixed yet
but has been analyzed as a need to upgrade the BIOS.

Then as I said before, I have this problem with stats buffer I know have a
phantoom query:

Script started on Sun Feb  1 20:05:56 2004
~ 20:05:56: psql
Welcome to psql 7.4.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit
 

ohp=# SELECT * from pg_stat_activity ;datid | datname  | procpid | usesysid | usename  |
                                             current_query
               |             query_start
 

-------+----------+---------+----------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------38920
|sdewitte |   27575 |    60004 | sdewitte | <IDLE>
                                                                                           | Sun 01 Feb 20:06:01.867356
2004MET38920 | sdewitte |   27577 |    60004 | sdewitte | select lieu_cod from lieu_position,perso_position,lieu where
ppos_perso_cod= 41980 and ppos_pos_cod = lpos_pos_cod and lpos_lieu_cod = lieu_cod and lieu_refuge = 'O'  | Sun 01 Feb
20:06:01.8687472004 MET38920 | sdewitte |    6518 |    60004 | sdewitte | select count(*) from perso_identifie_objet
wherepio_perso_cod = 53314 and pio_obj_cod = 28204
   | Sun 01 Feb 18:30:37.835876 2004 MET38915 | ohp      |   27574 |      101 | ohp      | <IDLE>

                 | Sun 01 Feb 20:06:00.472581 2004 MET
 
(4 rows)

ohp=# \q
~ 20:06:04: exit

script done on Sun Feb  1 20:06:04 2004
Feb  1 18:31:02 server postgres[1759]: [61-1] LOG:  statistics buffer is full
Feb  1 18:31:06 server postgres[6658]: [23-1] LOG:  recycled transaction log file "0000000A00000014"
Feb  1 18:31:40 server postgres[6868]: [23-1] LOG:  duration: 5298.605 ms  statement: VACUUM ANALYZE "public"."perso"
Feb  1 18:31:41 server postgres[6891]: [23-1] LOG:  duration: 2350.284 ms  statement: update perso set perso_der_connex
=now() where perso_cod = 30245
 
Feb  1 18:31:42 server postgres[6868]: [24-1] LOG:  duration: 2438.490 ms  statement: VACUUM ANALYZE
"public"."sessions_log"
Feb  1 18:31:45 server postgres[6888]: [23-1] LOG:  recycled transaction log file "0000000A00000015"
Feb  1 18:31:45 server postgres[6888]: [24-1] LOG:  recycled transaction log file "0000000A00000016"

As you can see, there was a stat buffer full at 18:31 and the process 6518
no longer exists but still shows up in pg_stat_activity.

How can I get rid of it short of restarting postgresql?

Regards,
-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)