I am using PostgreSQL 8.3.7 on a dedicated IBM 3660 with 24GB RAM running
CentOS 5.4 x86_64. I have a ServeRAID 8k controller with 6 SATA 7500RPM
disks in RAID 6, and for the OLAP workload it feels* slow. I have 6 more
disks to add, and the RAID has to be rebuilt in any case, but first I
In case you aren't comfortable running unreleased planner patches from
pgsql-hackers, a workaround was discussed on this list recently:
http://archives.postgresql.org/pgsql-performance/2009-09/msg00036.php
On Wed, 09 Sep 2009 06:05:22 -0400, Heikki Linnakangas
wrote:
Kevin Kempter wrote:
Thank you, Greg! I tweaked your function to use recursion to search all
inherited tables; my inheritance structure is two levels deep.
This function is for integers only; I will copy/waste to create one for
timestamps. Extra credit for anyone who can rewrite it to be polymorphic.
-- Same
With postgresql-8.3.6, I have many partitions inheriting a table. SELECT
min() on the parent performs a Seq Scan, but SELECT min() on a child uses
the index. Is this another case where the planner is not aware enough to
come up with the best plan? I tried creating an index on the parent ta
I wasn't able to compile dtrace on either CentOS 5.3 or Fedora 11. But
the author is responsive and the problem doesn't look hard to fix. It
sits in my inbox awaiting some hacking time...
Ken
On Thu, 06 Aug 2009 11:43:05 -0400, Ray Stell wrote:
On Thu, Aug 06, 2009 at 11:01:52AM -0400,
On Wed, 03 Jun 2009 05:29:02 -0400, Dimitri Fontaine
wrote:
Last time I used it it was in the context of a web application and to
compare PostgreSQL against Informix after a migration. So I used the
HTTP protocol support of the injector.
Tsung seems well suited for that.
Tsung is based on e
On Tue, 02 Jun 2009 05:26:41 -0400, Dimitri Fontaine
wrote:
I'd recommand having a look at tsung which will be able to replay a
typical application scenario with as many concurrent users as you want
to: http://archives.postgresql.org/pgsql-admin/2008-12/msg00032.php
http://tsung.erlang-pr