Postgres Pro
Downloads
Home   >   mailing lists

Re: Using "LIMIT" is much faster even though, searching - Mailing list pgsql-performance

From Hyun-Sung, Jang
Subject Re: Using "LIMIT" is much faster even though, searching
Date
Msg-id 41AD4AD0.908@siche.net
Whole thread Raw
In response to Re: Using "LIMIT" is much faster even though, searching with PK.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Using "LIMIT" is much faster even though, searching  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view
before test, I already executed VACUUM FULL.
this result show up after vacuum full.


Tom Lane 쓴 글: 
장현성 <siche@siche.net> writes: 
but, sequence scan, as you see above result, there is big time 
difference between using LIMIT and without using it.   
You've got a table full of dead rows.  Try VACUUM FULL ...
		regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using "LIMIT" is much faster even though, searching with PK.
Next
From: Josh Berkus
Date:
Subject: Re: Using "LIMIT" is much faster even though, searching