On Thu, Oct 29, 2009 at 11:50 AM, Lee Hachadoorian
wrote:
> I'm trying to update several tables (all child tables of the same
> parent), and as the number of records increases, the length of time it
> takes to run the update is shooting up exponentially. I have imported
> the new data to an import
Hi folks.
I did send an explain analyze last week but for some reason it didn't
appear on the list.
However, I've looked into the delay and it doesn't seem to be the SQL.
I'm now looking into why my PHP seems to sit there for 20+ seconds
doing nowt.
Thanks to everyone for the help anyway.
G
Gary Stainburn wrote:
Hi folks.
I've got my select working now, but I haven't received the speed
increase I'd expected. It replaced an earlier select which combined a
single explicit join with multiple froms.
The first select is the old one, the second one is the new one (with a
new join).
Try with creating INDEX on the used tables...It will make your search query
faster.
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Gary Stainburn
Sent: Friday, April 01, 2005 6:03 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Spee
Can you send the EXPLAIN ANALYZE of each? We can't really tell where
the slowdown is without that.
On Apr 1, 2005 12:32 PM, Gary Stainburn <[EMAIL PROTECTED]> wrote:
> Hi folks.
>
> I've got my select working now, but I haven't received the speed
> increase I'd expected. It replaced an earlier
>
>
> I would like to know is there is a specific way to speed up my query to
> postgres.
Please post the exact command line arguments you are giving when you start
the postmaster daemon process.
Cordially
Patrick Giagnocavo
[EMAIL PROTECTED]
Lets see your queries you're running and their plan, I'd bet there are ways
to speed them up (that's always been the case with mine!).. fields
- Mitch
"The only real failure is quitting."
- Original Message -
From: Alessandro Rossi <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Fri
