On Sat, Jan 15, 2011 at 14:56, Barbara Woolums wrote:
> Hi there,
>
> Could someone please tell me why the following query won't work
>
> select DISTINCT get_unit(unit) as unit, get_ingredient(ing) as ing,
> get_ing_aisle(1,ing) as aisle
> from recipe_ing where recipe in(1084, 1086, 1012, 618) an
Hi there,
Could someone please tell me why the following query won't work
select DISTINCT get_unit(unit) as unit, get_ingredient(ing) as ing,
get_ing_aisle(1,ing) as aisle
from recipe_ing where recipe in(1084, 1086, 1012, 618) and qtydec>0 and ing not
in(select ing from excluded_ing where own
On Fri, Mar 24, 2006 at 08:46:54AM -0600, Dave Dutcher wrote:
> > > The machine has 2x Intel dual core processors (3GHz) and 2 Gigs of
> ram.
> >
> > Unless I missed some big news recently, no such CPU exists.
> > Hyperthreading is absolutely not the same as dual core, and many
> people
> > have f
> From: [EMAIL PROTECTED]
[mailto:pgsql-performance-
> [EMAIL PROTECTED] On Behalf Of Jim C. Nasby
> Subject: Re: [PERFORM] Problem with query, server totally unresponsive
>
> On Thu, Mar 23, 2006 at 01:12:08PM +0100, Bendik Rognlien Johansen
wrote:
> > Hello, I have a bi
On Thu, Mar 23, 2006 at 01:12:08PM +0100, Bendik Rognlien Johansen wrote:
> Hello, I have a big problem with one of my databases. When i run my
> query, after a few minutes, the postmaster shows 99% mem i top, and
> the server becomes totally unresponsive.
You've got a bunch of sorts going on;
Seems the problem was with the custom aggregate function not being
able to handle thousands of rows.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello, I have a big problem with one of my databases. When i run my
query, after a few minutes, the postmaster shows 99% mem i top, and
the server becomes totally unresponsive.
I get this message when I try to cancel the query:
server closed the connection unexpectedly
This probably
