.18..4.18 rows=218 width=8) (actual
time=0.946..0.946 rows=0 loops=1)
-> 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]>
--
t of an auto disable 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 invo
ing the way the rows 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
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'
I'm 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
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 1
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 hel
