| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE ADD COLUMN fast default |
| Date: | 2018-03-08 13:11:33 |
| Message-ID: | CAKJS1f-tnAcD0whHcGyZVPGRrJoCPo9ZajtEFV2BDgCwKP+DVw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 8 March 2018 at 18:40, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> wrote:
> select * from t;
> fastdef tps = 107.145811
> master tps = 150.207957
>
> "select * from t" used to be about a wash, but with this patch it's
> got worse. The last two queries were worse and are now better, so
> that's a win.
How does it compare to master if you drop a column out the table?
Physical tlists will be disabled in that case too. I imagine the
performance of master will drop much lower than the all columns
missing case.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-03-08 13:46:56 | Re: Failed to request an autovacuum work-item in silence |
| Previous Message | Pavan Deolasee | 2018-03-08 12:54:25 | Re: [HACKERS] MERGE SQL Statement for PG11 |