From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Brett Toolin <brett(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Postgres 7.2.2 Segment Error |
Date: | 2002-09-20 03:47:40 |
Message-ID: | Pine.LNX.4.21.0209201347080.8055-100000@linuxworld.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 20 Sep 2002, Christopher Kings-Lynne wrote:
> > > DELETE FROM users_sessions WHERE changed < ('now'::timestamp - '1440
> > > minutes'::interval) AND name = 'fhnid';
> >
> > What does EXPLAIN show as the plan for that query? I'm guessing an
> > indexscan, and that the error was caused by reading a broken item
> > pointer from the index. (1342198864 = hex 50005450, which sure looks
> > like the upper 5 shouldn't be there ... how big is the table, anyway?)
>
> NOTICE: QUERY PLAN:
>
> 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?
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-09-20 03:48:07 | Re: Bug: COPY IN doesn't test domain constraints |
Previous Message | Christopher Kings-Lynne | 2002-09-20 03:38:00 | Re: DROP COLUMN misbehaviour with multiple inheritance |