Re: [DOCS] docs update for count(*) and index-only scans

2011-11-04 Thread Scott Marlowe
On Fri, Nov 4, 2011 at 2:10 PM, Robert Haas wrote: > On Tue, Nov 1, 2011 at 8:07 PM, Tom Lane wrote: >> It's the "lobotomized engines" that are the problem, IMO --- people >> coming from databases like mysql tend to think count(*) just means >> reading a table size counter that the engine has any

Re: [DOCS] docs update for count(*) and index-only scans

2011-11-04 Thread Robert Haas
On Tue, Nov 1, 2011 at 8:07 PM, Tom Lane wrote: > It's the "lobotomized engines" that are the problem, IMO --- people > coming from databases like mysql tend to think count(*) just means > reading a table size counter that the engine has anyway. This is probably a much less common misconception t

Re: [DOCS] PGDATA confusion

2011-11-04 Thread Bruce Momjian
Thom Brown wrote: > > So if one set PGDATA to somewhere which had no database files at all, > > but just postgresql.conf, it could still work (assuming it, in turn, > > set data_directory correctly), but not vice versa. ?It would make more > > sense to call it PGCONFIG, although I'm not proposing t