Fredrik Bertilsson wrote:
Hi,
we are using Postgres on both Solaris servers and Linux servers, and
Postgres are much slower on Solaris servers. We have tested with
different versions of Solaris and Postgres, but the fact remains:
Postgres seems to be much faster on Linux server. Does anybody e
10 aug 2007 kl. 22:58 skrev Nurlan Mukhanov:
Hello All.
I have a table with ca. 100.000.000 records. The main idea is make
Partitioning for this table (1000 or 1 tables).
Let's take for example.
CREATE TABLE test
(
id integer,
data date not null default now()
)
WITHOUT OIDS;
CREATE T
>>> On Fri, Aug 10, 2007 at 11:57 AM, in message
<[EMAIL PROTECTED]>, "Relyea,
Mike" <[EMAIL PROTECTED]> wrote:
> I'm have the following view as part of a larger, aggregate query that is
> running slower than I'd like.
> . . .
> HAVING "PrintSamples"."MachineID" = 4741 OR "PrintSamples"."MachineID
>>> On Fri, Aug 10, 2007 at 11:57 AM, in message
<[EMAIL PROTECTED]>, "Relyea,
Mike" <[EMAIL PROTECTED]> wrote:
> HAVING "PrintSamples"."MachineID" = 4741 OR "PrintSamples"."MachineID" =
> 4745 AND . . .
On top of the issue in my prior email, I don't see any test for 4745 in the
EXPLAIN ANALYZE
