Re: Postgres 7.2.2 Segment Error - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Postgres 7.2.2 Segment Error
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEFLCEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Postgres 7.2.2 Segment Error  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
> > Index Scan using users_sessions_cha_name_idx on users_sessions
> > (cost=0.00..12738.07 rows=1275 width=6) (actual
> time=231.74..239.39 rows=2
> > loops=1)
> > Total runtime: 239.81 msec
> >
> > EXPLAIN
> >
> > The size of the table:
> >
> > canaveral# ls -al 44632
> > -rw-------  1 pgsql  pgsql  357130240 Sep 19 18:52 44632
>
> This seems remarkably large. Does pg_filedump reveal anything of interest?

Where on earth do I find that?

BTW - I want to vacuum full this table but I'm holding off until someone
like Tom tells me there's nothing more to be gained from it...

Chris



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Win32 rename()/unlink() questions
Next
From: Mike Mascari
Date:
Subject: Re: Win32 rename()/unlink() questions