Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * FROM LIMIT 1; is really slow - Mailing list pgsql-hackers
From Christopher Kings-Lynne
Subject Re: SELECT * FROM LIMIT 1; is really slow
Date
Msg-id 40B54621.1070001@familyhealth.com.au
Whole thread Raw
In response to Re: SELECT * FROM LIMIT 1; is really slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SELECT * FROM LIMIT 1; is really slow
List pgsql-hackers
Tree view 
> It wouldn't; you'd need vacuum full to collapse out the dead space.
> You could also try CLUSTER which is faster than VACUUM FULL when most
> of the data has to be moved anyway.  (Some days I think we should dump
> VACUUM FULL, because it's optimized for a case that's no longer very
> interesting...)

Out of interest, is CLUSTER another fast way of truly removing OIDs from 
a table, after going SET WITHOUT OIDS?

Chris

pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Nested xacts: looking for testers and review
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: tablespaces and DB administration