"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> The sessions table holds normal site session data, like a uid, username,
> some other stuff, etc. However entries older than two hours or so get
> deleted. We VACUUM everynight, so why is the on-disk relation growing so
> huge?
FSM not big
> > 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 pg
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
> > 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 =
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> I just saw this in my logs:
> 2002-09-18 12:13:10 ERROR: cannot open segment 1 of relation users_sessions
> (target block 1342198864): No such file or directory
> This query caused it:
> DELETE FROM users_sessions WHERE changed < ('now'::t
I just saw this in my logs:
2002-09-18 12:13:10 ERROR: cannot open segment 1 of relation users_sessions
(target block 1342198864): No such file or directory
This query caused it:
DELETE FROM users_sessions WHERE changed < ('now'::timestamp - '1440
minutes'::interval) AND name = 'fhnid';
Howe
