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 file
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 WHER
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 ago
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 desc
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):
tl
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-15M
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 expe
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 ha
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 retur
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
Bruno Wolff III wrote:
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
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 t
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
14 matches
Mail list logo