Vivek,
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 it to be more "Postgres friendly" - meaning less
data
Alexandre Leclerc <[EMAIL PROTECTED]> writes:
> -- suppose this view (used many times):
> CREATE VIEW prod.alljobs_view AS
> SELECT *
> FROM prod.jobs
> LEFT JOIN prod.jobs_products ON jobs.job_id = jobs_products.job_id;
> -- suppose this other query:
> CREATE VIEW prod.orders_jobs_view AS
I'm just currious about which is the best, if I have many query based
on the first one:
-- suppose this view (used many times):
CREATE VIEW prod.alljobs_view AS
SELECT *
FROM prod.jobs
LEFT JOIN prod.jobs_products ON jobs.job_id = jobs_products.job_id;
-- suppose this other query:
CREATE
Sorry if I'm contributing more noise to the signal here, just thought
I'd repost this one to the list since it may have gotten lost in all
the garbage from the guy unhappy about the usenet thing..
-- Forwarded message --
From: Allen Landsidel <[EMAIL PROTECTED]>
Date: Fri, 12 Nov
Hi,
I have a strange (for me) result ... Why the second request is really quicker
with a Seq Scan than the first one with a DISTINCT and using an index !?
The table have really 183957 rows ... not like the Seq Scan seems to
expect ... !? I understand nothing here ...
Thanks for your explanatio
Alexandre,
> -- Assuming those tables (not original, but enought to get the point):
>
> CREATE TABLE prod.jobs (
> job_id serial PRIMARY KEY,
> order_idinteger NOT NULL REFERENCES sales.orders,
> );
>
> CREATE TABLE design.products (
> product_id serial PRIMARY KE
Good day,
I use pgsql 7.4: I would like to know if indexes will solve my problem
(I fear the system will become slow with the time). And also some
questions on how pgsql optimise for speed.
*Database*
-- Assuming those tables (not original, but enought to get the point):
CREATE TABLE prod.jobs
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joshua Marsh wrote:
| Thanks for all of your help so far. Here is some of the information
| you guys were asking for:
|
| Test System:
| 2x AMD Opteron 244 (1.8Ghz)
| 8GB RAM
| 7x 72GB SCSI HDD (Raid 5)
You probably want to look at investing in a SAN.
Greg Stark wrote:
William Yu <[EMAIL PROTECTED]> writes:
Biggest speedup I've found yet is the backup process (PG_DUMP --> GZIP). 100%
faster in 64-bit mode. This drastic speed might be more the result of 64-bit
GZIP though as I've seen benchmarks in the past showing encryption/compression
running
