mvh= set time zone 'UTC';
SET
mvh= select now();
now
---
2007-02-13 03:37:35.660652+00
(1 row)
mvh= select timestamp with time zone '2007-01-01' at time zone
'America/Los_Angeles';
timezone
-
2006-12-31
using FreeBSD , so any FreeBSD related hints are appreciated, but I
can run Linux or whatever if needed for this server.
Thanks,
--
Mike Harding [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once
Sorry, I should have said 'vacuum analyze verbose'...
On Sat, 2005-02-26 at 00:45 -0500, Greg Stark wrote:
Mike Harding [EMAIL PROTECTED] writes:
The following was run -immediately- after a vacuum.
You realize vacuum doesn't update the statistics, right?
You have to do analyze or vacuum
)
- Seq Scan on countries (cost=0.00..4.18
rows=218 width=8) (actual time=0.011..0.516 rows=218 loops=1)
Total runtime: 175404.738 ms
(10 rows)
--
Mike Harding [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your
of the hashagg.
On Fri, 2005-02-25 at 16:55 -0500, Tom Lane wrote:
Mike Harding [EMAIL PROTECTED] writes:
I've been having problems where a HashAggregate is used because of a bad
estimate of the distinct number of elements involved.
If you're desperate, there's always enable_hashagg
were processed by the query.
No, but you can easily keep a counter in the client.
--
Mike Harding [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Suppose I have some tables and views like so for dog breeds and
breeders and their inventory where I also have a 'human' view of dog
inventory where the breed and breeder names are displayed instead of
the numerical IDs. I've gotten inserts working but I'm stymied by
updates and deletes... any
