Hi,
I have an application where I drop, recreate, reload, and recreate
indexes on a 1 million row table each day. I do this to avoid having to
run vacuum on the table in the case where I might use DELETE or UPDATEs
on deltas.
It seems that running vacuum still has value in the above approach
bec
Title: Multi Time Zone Select
Hi,
I load date information from different time zones into a single table. My columns are defined 'timestamp(0) with time zone' and I'm loading '2005-03-01 22:00:00-05:00' and '2005-03-01 23:00:00-06:00' for example. I query this table and expect rows from all
Title: Message
Hi,
I need to calculate
a moving average and I would like to do it with SQL, or a Pg function built for
this purpose. I'm on Pg 7.4. Is this possible in Pg without a bunch of self
joins, or is there a funtion available?
Thanks,
Mike
