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
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
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
>> >
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
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
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
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
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
[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
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
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
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
> >
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
13 matches
Mail list logo