hat points to the
current output file.
- gzips the rotated logfile
If you have gnu tools installed, you can
tail --retry --follow=name foo.current
and it will automatically track the most recent
log file.
HTH,
Mark
--
Mark Harrison
Pixar Animation Studios
*** rotatelogs.c-orig 2004-03-10
g where id = 123123123123123;
LOG: duration: 6376.917 ms statement: select * from big where id = 123;
One thing I have considered is starting our id sequence at 50
so that "real" queries will always be bigint-sized, but this seems
to me a bit of a hack.
Many TIA,
Mark
--
Mark Harr
Jan Wieck wrote:
It might not work with the words I used above, but the point I tried to
make is that the hardest thing you can "sell" is a "no". I mean, not
just saying "no", but selling it in a way that the customer will not go
with the next idiot who claims "we can do that".
But you will need
of these do exactly what I need...
Cheers,
Mark
--
Mark Harrison
Pixar Animation Studios
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
apsed 9.32 sec.
INFO: Analyzing public.bigtable
VACUUM
testdb=# explain select * from bigtable where id = 123;
QUERY PLAN
---
Seq Scan on bigtable (cost=0.00..57410.39 rows=1 width=16)
Filter: (id = 123)
(2 rows)
--
