Jessica Richard wrote:
> I have a large table with about 2 million rows and it will keep
> growing...
>
> I need to do update/inserts, and select as well.
>
> An index will speed up the select, but it will slow down the updates.
>
> Are all Postgres indexes ordered? i.e., with every update, the
We're about to try out a new BBU controller card, and would welcome
any advice from anyone with experience with this hardware.
It is an IBM ServeRAID-MR10M SAS/SATA Controller with the optional
BBU. The docs say it is "a LSI1078ROC-based PCI Express RAID
adapter." We're hooking it up to four dr
I have a large table with about 2 million rows and it will keep growing...
I need to do update/inserts, and select as well.
An index will speed up the select, but it will slow down the updates.
Are all Postgres indexes ordered? i.e., with every update, the index pages will
have to be physically
This may be of interest...
http://weblog.infoworld.com/yager/archives/2008/05/ahead_of_the_cu_4.html
-Original Message-
From: [EMAIL PROTECTED] on behalf of Andrzej Zawadzki
Sent: Fri 5/23/2008 6:41 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Quad Xeon or Quad Opteron?
H
Hi,
As a gauge, we recently purchased several servers as our systems get
close to going operational. We bought Dell 2900s, with the cheapest quad
core processors (dual) and put most of the expense into lots of drives
(8 15K 146GB SAS drives in a RAID 10 set), and the PERC 6 embedded
controller with
> Also, based on what I've seen on this list rather than personal
> experience, you might want to give more thought to your storage than to
> CPU power. The usual thrust of advice seems to be: Get a fast, battery
> backed RAID controller. "Fast" does not mean "fast sequential I/O in
> ideal conditi
Andrzej Zawadzki wrote:
> Hello,
>
> We're planning new production server for PostgreSQL and I'm wondering
> which processor (or even platform) will be better: Quad Xeon or Quad
> Opteron (for example SUN now has a new offer Sun Fire X4440 x64).
[snip]
> Suggestions?
To get a more useful respo
Hello,
We're planning new production server for PostgreSQL and I'm wondering
which processor (or even platform) will be better: Quad Xeon or Quad
Opteron (for example SUN now has a new offer Sun Fire X4440 x64).
When I was buying my last database server, then SUN v40z was a really
very good choi
I wonder why join_collapse_limit default values is set to 8 but
geqo_threshold is 12. Optimizer doesn't change the order of JOIN's of
queries that contains from 8 to 11 tables. Why it's 'wise' decision as
documentation says?
from_collapse_limit (integer)
The planner will merge sub-queries