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,
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
\d
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
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
[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 lot of
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
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
found old
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 2000.
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
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 someday it
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
done
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 support
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, once
13 matches
Mail list logo