Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance
Date
Msg-id 18374.1038416224@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tree view 
Oleg Bartunov <oleg@sai.msu.su> writes:
> Are there any reason to "fetch (and perhaps decompress) the TOAST entries"
> just to count(*) without any WHERE clause ?

It doesn't.  That was my point...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: contrib/ltree patches
Next
From: "scott.marlowe"
Date:
Subject: Re: [PERFORM] Realtime VACUUM, was: performance of