On Tue, 2004-06-01 at 23:16, V i s h a l Kashyap @ [Sai Hertz And
Control Systems] wrote:
> Dear all,
>
> Have anyone compiled PostgreSQL with kernel 2.6.x
> if YES
> 1. Was their any performance gains
OSDL reports approx 20% improvement. I've seen similar with some data
access patterns.
> 2. W
Dear all,
Have anyone compiled PostgreSQL with kernel 2.6.x
if YES
1. Was their any performance gains
Else
1. Is it possible
2. What problems would keeping us away from compiling on kernel 2.6
--
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Lt
This was a lively debate on what was faster, single spindles or RAID.
This is important, because I keep running into people who do not
understand the performance dynamics of a RDBMS like Oracle or Pg.
Pg and Oracle make a zillion tiny reads and writes and fsync()
regularly. If your drive will c
Hello pgsql-performance,
I was using the native windows PostgreSQL 7.5Dev and was adviced by
several people to use an emulated PostgreSQL instead, as it is just
a beta.
Well, I give it a whirl and tried both commercial VMWare and the
freeweare open-source CoLinux, both work under Window
> My problem is I defined the "before" and "after"
> fields in the audit table as TEXT and when I try to move NEW or OLD into
> these fields I get the error "NEW used in query that is not in a rule".
You're trying to insert record data into a text field, that doesn't work.
OLD and NEW can be use
Title: Trigger & Function
I'm trying to create a trigger (AFTER INSERT, UPDATE, DELETE) as an audit routine inserting into an audit table the "before" and "after" views of the row being acted upon. My problem is I defined the "before" and "after" fields in the audit table as TEXT and when I t
On Fri, 13 Feb 2004 16:21:29 +0100, I wrote:
>Populate this table with
> INSERT INTO idmap
> SELECT id, id, true
> FROM t;
This should be
INSERT INTO idmap
SELECT DISTINCT id, id, true
FROM t;
Servus
Manfred
---(end of broadc
