Re: Performance issues of one vs. two split tables. - Mailing list pgsql-general

From PFC
Subject Re: Performance issues of one vs. two split tables.
Date
Msg-id op.tscwaax9cigqcu@apollo13
Whole thread Raw
In response to Re: Performance issues of one vs. two split tables.  ("Dawid Kuroczko" <qnex42@gmail.com>)
List pgsql-general

> Say, if you first SELECT fname, lname FROM user_table;
> and then you issue SELECT * FROM user_table; -- the
> second select will be returned from buffer cache -- since
> all rows are already in the cache.

    ...Unless your table contains some large TEXT columns that have been
stored out of line (TOASTed) by postgres.

pgsql-general by date:

Previous
From: "Dawid Kuroczko"
Date:
Subject: Re: Performance issues of one vs. two split tables.
Next
From: Magnus Hagander
Date:
Subject: Re: dns less connection