Tobias Brox wrote:
[EMAIL PROTECTED] - Fri at 12:10:19PM -0400]
tle-bu= EXPLAIN ANALYZE SELECT file_type, file_parent_dir, file_name FROM
file_info_7;
QUERY PLAN
Madison Kelly [EMAIL PROTECTED] writes:
Here is my full query:
tle-bu= EXPLAIN ANALYZE SELECT file_name, file_parent_dir, file_type
FROM file_info_7 WHERE file_type='d' ORDER BY file_parent_dir ASC,
file_name ASC;
This is my index (which I guess is wrong):
tle-bu= \d
On Sun, Jun 12, 2005 at 10:12:27 -0400,
Madison Kelly [EMAIL PROTECTED] wrote:
Indexes:
file_info_7_display_idx btree (file_type, file_parent_dir, file_name)
Here is my full query:
tle-bu= EXPLAIN ANALYZE SELECT file_name, file_parent_dir, file_type
FROM file_info_7 WHERE
Hi,
I'm trying to update a table that has about 600.000 records.
The update query is very simple :update mytable set pagesdesc = - pages ;
(I use pagesdesc to avoid problems with sort that have one field in ascending order and one in descending order. That was a problem I had a week
Hi,
At 19:40 12/06/2005, Yves Vindevogel wrote:
Hi,
I'm trying to update a table that has about 600.000 records.
The update query is very simple :update mytable set pagesdesc = -
pages ;
(I use pagesdesc to avoid problems with sort that have one field in
ascending order and one in
Tom Lane wrote:
Madison Kelly [EMAIL PROTECTED] writes:
Here is my full query:
tle-bu= EXPLAIN ANALYZE SELECT file_name, file_parent_dir, file_type
FROM file_info_7 WHERE file_type='d' ORDER BY file_parent_dir ASC,
file_name ASC;
This is my index (which I guess is wrong):
I've got a list of old resource requirements.
I want to know how far off they are and if anything
crucial is missing. My usual recommendation is
as much as you can afford so I don't usually deal
with real numbers :)
RAM:
Number of connections * 2MB
Disk:
Program and Manual 8-15MB
Yves Vindevogel wrote:
I'm trying to update a table that has about 600.000 records.
The update query is very simple : update mytable set pagesdesc = - pages ;
The query takes about half an hour to an hour to execute. I have tried a
lot of things.
Half an hour seem a bit long - I would
On Sun, Jun 12, 2005 at 18:52:05 -0400,
Madison Kelly [EMAIL PROTECTED] wrote:
After sending that email I kept plucking away and in the course of
doing so decided that I didn't need to return the 'file_type' column.
Other than that, it would see my query now matches what you two have
On Sun, Jun 12, 2005 at 22:00:01 -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
On Sun, Jun 12, 2005 at 18:52:05 -0400,
Madison Kelly [EMAIL PROTECTED] wrote:
After sending that email I kept plucking away and in the course of
doing so decided that I didn't need to return the
Bruno Wolff III wrote:
On Sun, Jun 12, 2005 at 18:52:05 -0400,
Madison Kelly [EMAIL PROTECTED] wrote:
After sending that email I kept plucking away and in the course of
doing so decided that I didn't need to return the 'file_type' column.
Other than that, it would see my query now matches
On Sun, Jun 12, 2005 at 23:42:05 -0400,
Madison Kelly [EMAIL PROTECTED] wrote:
As you probably saw in my last reply, I went back to the old index and
tried the query you and Tom Lane recommended. Should this not have
caught the index?
Probably, but there might be some other reason the
Bruno Wolff III wrote:
On Sun, Jun 12, 2005 at 23:42:05 -0400,
Madison Kelly [EMAIL PROTECTED] wrote:
As you probably saw in my last reply, I went back to the old index and
tried the query you and Tom Lane recommended. Should this not have
caught the index?
Probably, but there might be
13 matches
Mail list logo