Re: [SQL] Speed up UPDATE query?

2009-10-31 Thread Scott Marlowe
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

[SQL] Speed up UPDATE query?

2009-10-29 Thread Lee Hachadoorian
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 table, and then join the import table to the update table. The upd

Re: [SQL] Speed up slow select - was gone blind

2005-04-05 Thread Gary Stainburn
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

Re: [SQL] Speed up slow select - was gone blind

2005-04-01 Thread Richard Huxton
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).

Re: [SQL] Speed up slow select - was gone blind

2005-04-01 Thread Dinesh Pandey
] Speed up slow select - was gone blind 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

Re: [SQL] Speed up slow select - was gone blind

2005-04-01 Thread Mike Rylander
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

[SQL] Speed up slow select - was gone blind

2005-04-01 Thread Gary Stainburn
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). The new one takes 24

[SQL] speed up creation of a table

2001-02-18 Thread Alexaki Sofia
Hello, I have two questions concerning space and time required to load huge volume of data in the DBMS. To note I use JDBC interface to load the schema and data in the postgresql In order to create the tables contained in my database I use the command stmt.executeUpdate("CREATE TABLE t1

Re: [SQL] SPEED UP.

2000-06-02 Thread Patrick Giagnocavo
> > > 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]

Re: [SQL] SPEED UP.

2000-06-02 Thread Mitch Vincent
t; To: <[EMAIL PROTECTED]> Sent: Friday, June 02, 2000 2:49 AM Subject: [SQL] SPEED UP. > > > I would like to know is there is a specific way to speed up my query to > postgres. > > I have a DB-MACHINE that I use just and only for postgres witch runs > linux RedHad 6.2 w

[SQL] SPEED UP.

2000-06-02 Thread Alessandro Rossi
I would like to know is there is a specific way to speed up my query to postgres. I have a DB-MACHINE that I use just and only for postgres witch runs linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs. I run vacuum every hour, but there is something else I can do (compile postgres in a spec