Re: [PERFORM] Indexes with descending date columns

2006-03-23 Thread Tom Lane
Theo Kramer <[EMAIL PROTECTED]> writes: > If so, I would appreciate any pointers on where to start on this - > already fumbling my way through Interfacing Extensions To Indexes in the > manual... Search the PG list archives for discussions of reverse-sort opclasses. It's really pretty trivial, onc

Re: [PERFORM] Indexes with descending date columns

2006-03-23 Thread Theo Kramer
On Thu, 2006-03-23 at 16:16, Alvaro Herrera wrote: > Theo Kramer wrote: > > > All good input - thanks, however, before I start messing with my stuff > > which I know will be complex - some questions to any of the developers > > on the list. > > > > i Is it feasible to extend index creation to su

Re: [PERFORM] Scaling up PostgreSQL in Multiple CPU / Dual Core

2006-03-23 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Scott Marlowe) wrote: > On Thu, 2006-03-23 at 10:43, Joshua D. Drake wrote: >> > Has someone been working on the problem of splitting a query into pieces >> > and running it on multiple CPUs / multiple machines? Yes. Bizgress has >> >

Re: [PERFORM] Scaling up PostgreSQL in Multiple CPU / Dual Core

2006-03-23 Thread Scott Marlowe
On Thu, 2006-03-23 at 10:43, Joshua D. Drake wrote: > > Has someone been working on the problem of splitting a query into pieces > > and running it on multiple CPUs / multiple machines? Yes. Bizgress has > > done that. > > I believe that is limited to Bizgress MPP yes? Yep. I hope that somed

Re: [PERFORM] Scaling up PostgreSQL in Multiple CPU / Dual Core

2006-03-23 Thread Joshua D. Drake
Has someone been working on the problem of splitting a query into pieces and running it on multiple CPUs / multiple machines? Yes. Bizgress has done that. I believe that is limited to Bizgress MPP yes? ---(end of broadcast)--- TIP 9: In v

Re: [PERFORM] Scaling up PostgreSQL in Multiple CPU / Dual Core

2006-03-23 Thread Scott Marlowe
On Thu, 2006-03-23 at 00:19, Jojo Paderes wrote: > I'd like to know if the latest PostgreSQL release can scale up by > utilizing multiple cpu or dual core cpu to boost up the sql > executions. > > I already do a research on the PostgreSQL mailing archives and only > found old threads dating back 2

Re: [PERFORM] Scaling up PostgreSQL in Multiple CPU / Dual Core

2006-03-23 Thread Frank Wiles
On Thu, 23 Mar 2006 14:19:24 +0800 "Jojo Paderes" <[EMAIL PROTECTED]> wrote: > I'd like to know if the latest PostgreSQL release can scale up by > utilizing multiple cpu or dual core cpu to boost up the sql > executions. > > I already do a research on the PostgreSQL mailing archives and only > fo

[PERFORM] Problem with query, forget previous message

2006-03-23 Thread Bendik Rognlien Johansen
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

Re: [PERFORM] Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers

2006-03-23 Thread Christopher Browne
[EMAIL PROTECTED] ("Jojo Paderes") wrote: > I'd like to know if the latest PostgreSQL release can scale up by > utilizing multiple cpu or dual core cpu to boost up the sql > executions. > > I already do a research on the PostgreSQL mailing archives and only > found old threads dating back 2000. A l

Re: [PERFORM] Indexes with descending date columns

2006-03-23 Thread Alvaro Herrera
Theo Kramer wrote: > All good input - thanks, however, before I start messing with my stuff > which I know will be complex - some questions to any of the developers > on the list. > > i Is it feasible to extend index creation to support descending >columns? ... this is supported on other co

[PERFORM] Problem with query, server totally unresponsive

2006-03-23 Thread Bendik Rognlien Johansen
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

Re: [PERFORM] Indexes with descending date columns

2006-03-23 Thread Theo Kramer
On Fri, 2006-03-17 at 08:25, [EMAIL PROTECTED] wrote: > > I have a performance problem when traversing a table in index order with > > multiple columns including a date column in date reverse order. Below > > follows a simplified description of the table, the index and the > > associated query > >

Re: [PERFORM] Postmaster using only 4-5% CPU

2006-03-23 Thread Edoardo Serra
At 18.44 21/03/2006, Scott Marlowe wrote: Here's what's happening. On the "fast" machine, you are almost certainly using IDE drives. Oh yes, the fast machine has IDE drives, you got it ;) Meanwhile, back in the jungle... The machine with IDE drives operates differently. Most, if not all, I