On Sat, 2004-11-13 at 18:00, [EMAIL PROTECTED] wrote:
> I ran into the exact same problem you did. I tried many, many changes to
> the conf file, I tried O.S. tuning but performance stunk. I had a fairly
> simple job that had a lot of updates and inserts that was taking 4 1/2
> hours. I re-wrote
3 Nov 2004 03:26:09 -0800 (PST)
To: [EMAIL PROTECTED]
Subject: [PERFORM] Insertion puzzles
Hello to all,
I am new to this group and postgresql. I am working on
a project which uses postgresql and project is time
critical. We did all optimization in our project but
postgresql seems to be a bottl
Actually, the most damning thing in this configuration I had missed earlier
256MB of ram !
Dave
Josh Berkus wrote:
Vivek,
Redhat Linux7.2
RAM: 256MB
postgres: 7.1.3
Um, you do realise that both RH 7.2 and PostgreSQL 7.1 are "no longer
supported" but their respective communities?
--
Dav
Vivek,
> Redhat Linux7.2
> RAM: 256MB
> postgres: 7.1.3
Um, you do realise that both RH 7.2 and PostgreSQL 7.1 are "no longer
supported" but their respective communities?
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
On Sat, 13 Nov 2004, vivek singh wrote:
> I am new to this group and postgresql. I am working on
> a project which uses postgresql and project is time
> critical. We did all optimization in our project but
> postgresql seems to be a bottle-neck. To solve this we
> run the database operations in a
Well, the default configuration for postgresql 7.1.3 is *very*
conservative. ( ie. very slow)
You should seriously consider upgrading to 7.4.6 as server performance
has increased; in some cases significantly.
If that is not an option, certainly tuning the shared buffers, and
effective cache se
On Nov 13, 2004, at 12:26, vivek singh wrote:
But
still, with large volume of data in database the
insert operation becomes very slow (ie. to insert 100
records in 5 tables, it takes nearly 3minutes).
What are the performance when you use COPY FROM instead of INSERT ?
And have you tested the perfo
Hello to all,
I am new to this group and postgresql. I am working on
a project which uses postgresql and project is time
critical. We did all optimization in our project but
postgresql seems to be a bottle-neck. To solve this we
run the database operations in a different thread. But
still, with la
