Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * FROM LIMIT 1; is really slow - Mailing list pgsql-hackers
From Gaetano Mendola
Subject Re: SELECT * FROM LIMIT 1; is really slow
Date
Msg-id c931ha$cs6$2@floppy.pyrenet.fr
Whole thread Raw
In response to SELECT * FROM LIMIT 1; is really slow  (David Blasby <dblasby@refractions.net>)
Responses Re: SELECT * FROM LIMIT 1; is really slow  (David Blasby <dblasby@refractions.net>)
List pgsql-hackers
Tree view 
David Blasby wrote:

> I have a table with about 16,000,000 rows in it.
> 
> When I do a:
> 
> SELECT * FROM <table> LIMIT 1;
> 
> it takes about 10 minutes (thats about how long it takes to do a full 
> sequential scan).
> 
> I had originally thought that there might be a large number of 
> "wasted/retired" tuples in the table so I "vacuum analysed" the 
> database.  It had no effect.  I had a "vacuum full" going on the table 
> for 17 hours before I killed it.

Are you sure that the vacuum full was running or sitting there to
wait an idle transaction ?


Regards
Gaetano Mendola

pgsql-hackers by date:

Previous
From: David Blasby
Date:
Subject: SELECT * FROM LIMIT 1; is really slow
Next
From: David Blasby
Date:
Subject: Re: SELECT * FROM
LIMIT 1; is really slow