Re: WIP: Avoid creation of the free space map for small tables

From:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:	Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc:	John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: WIP: Avoid creation of the free space map for small tables
Date:	2019-02-20 14:38:25
Message-ID:	20190220143825.GA2534@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-10-05 18:47:11 from John Naylor <jcnaylor(at)gmail(dot)com> 📎  2018-10-05 20:42:26 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>   2018-10-07 15:17:24 from John Naylor <jcnaylor(at)gmail(dot)com> 📎    2018-10-07 15:41:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2018-10-08 10:49:03 from John Naylor <jcnaylor(at)gmail(dot)com>  2018-10-12 13:49:17 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>  2018-10-13 12:56:33 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2018-10-13 19:39:39 from John Naylor <jcnaylor(at)gmail(dot)com> 📎    2018-10-14 16:29:28 from John Naylor <jcnaylor(at)gmail(dot)com> 📎    2018-10-15 03:40:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2018-10-15 10:39:34 from John Naylor <jcnaylor(at)gmail(dot)com>      2018-10-16 03:48:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2018-10-22 06:44:27 from John Naylor <jcnaylor(at)gmail(dot)com> 📎        2018-10-23 13:42:02 from John Naylor <jcnaylor(at)gmail(dot)com> 📎         2018-10-31 08:12:08 from John Naylor <jcnaylor(at)gmail(dot)com> 📎          2018-10-31 13:09:07 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>         2018-10-31 16:59:21 from Robert Haas <robertmhaas(at)gmail(dot)com>          2018-11-02 11:22:58 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2018-11-02 13:59:33 from Robert Haas <robertmhaas(at)gmail(dot)com>            2018-11-02 14:07:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2018-11-02 14:38:45 from Robert Haas <robertmhaas(at)gmail(dot)com>              2018-11-02 17:20:58 from John Naylor <jcnaylor(at)gmail(dot)com>              2018-11-04 00:26:49 from Michael Paquier <michael(at)paquier(dot)xyz>               2018-11-04 03:58:58 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>              2018-11-05 09:28:17 from John Naylor <jcnaylor(at)gmail(dot)com>             2018-11-03 04:48:02 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>            2018-11-03 04:41:28 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>          2018-11-04 08:26:34 from John Naylor <jcnaylor(at)gmail(dot)com> 📎        2018-11-16 03:00:00 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>         2018-11-19 02:00:02 from John Naylor <jcnaylor(at)gmail(dot)com>          2018-11-19 05:06:02 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2018-11-19 11:10:17 from John Naylor <jcnaylor(at)gmail(dot)com>            2018-11-19 12:24:29 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>            2018-11-20 08:12:22 from John Naylor <jcnaylor(at)gmail(dot)com>             2018-11-20 12:48:19 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>         2018-11-23 06:26:43 from John Naylor <jcnaylor(at)gmail(dot)com> 📎          2018-11-24 07:49:36 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2018-11-26 10:16:50 from John Naylor <jcnaylor(at)gmail(dot)com>            2018-11-26 11:54:04 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>             2018-11-29 09:37:30 from John Naylor <jcnaylor(at)gmail(dot)com> 📎              2018-11-29 12:47:56 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>              2018-12-01 07:12:11 from John Naylor <jcnaylor(at)gmail(dot)com> 📎               2018-12-01 10:13:16 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                2018-12-03 04:05:32 from John Naylor <jcnaylor(at)gmail(dot)com>              2018-12-03 04:16:08 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>               2018-12-03 05:02:38 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                2018-12-03 05:45:01 from John Naylor <jcnaylor(at)gmail(dot)com>                 2018-12-03 06:29:29 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                  2018-12-06 17:23:28 from John Naylor <jcnaylor(at)gmail(dot)com> 📎                   2018-12-07 03:51:07 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                    2018-12-07 13:55:57 from John Naylor <jcnaylor(at)gmail(dot)com>                     2018-12-08 13:05:20 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                      2018-12-08 13:56:34 from John Naylor <jcnaylor(at)gmail(dot)com>                      2018-12-29 11:15:41 from Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>                       2018-12-29 22:19:58 from John Naylor <jcnaylor(at)gmail(dot)com>                        2018-12-31 03:49:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                        2019-01-04 02:53:00 from Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com> 📎                         2019-01-04 03:54:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                          2019-01-07 20:56:59 from John Naylor <jcnaylor(at)gmail(dot)com> 📎                           2019-01-08 20:33:08 from John Naylor <jcnaylor(at)gmail(dot)com>                           2019-01-09 12:33:37 from Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>                            2019-01-09 15:30:46 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                             2019-01-10 03:50:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                              2019-01-10 22:24:10 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                               2019-01-16 03:54:57 from Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>                                2019-01-16 13:45:05 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                               2019-01-16 13:41:14 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                2019-01-16 16:40:01 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                 2019-01-16 17:14:49 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                  2019-01-16 17:55:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                   2019-01-17 03:08:00 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                 2019-01-17 03:35:40 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                  2019-01-17 17:43:36 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                   2019-01-19 13:05:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                    2019-01-19 23:49:08 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                     2019-01-21 11:31:55 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                      2019-01-21 21:23:18 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                      2019-01-23 22:08:56 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                       2019-01-24 04:16:54 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                        2019-01-24 10:19:23 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                        2019-01-24 19:33:03 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                         2019-01-25 02:50:03 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                          2019-01-25 23:35:30 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                           2019-01-26 13:14:30 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                            2019-01-27 21:03:22 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                             2019-03-08 11:43:39 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2019-03-08 11:49:06 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2019-03-10 14:16:48 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                               2019-03-13 02:52:07 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2019-03-13 11:26:56 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                               2019-03-13 12:18:02 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                2019-03-13 14:12:03 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                 2019-03-13 15:27:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                  2019-03-14 01:38:33 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                   2019-03-14 06:17:29 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                    2019-03-14 07:07:01 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                     2019-03-14 14:16:41 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                      2019-03-15 09:55:34 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                       2019-03-15 10:10:16 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                        2019-03-16 01:29:53 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                       2019-03-18 02:28:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                          2019-01-25 23:38:50 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                          2019-03-06 11:49:26 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                           2019-03-08 11:45:31 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                     2019-01-23 12:08:52 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                      2019-01-23 15:48:28 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                       2019-01-24 03:44:19 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                        2019-01-28 02:53:06 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                         2019-01-28 03:46:33 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                          2019-01-28 03:53:17 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                           2019-01-28 04:33:12 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                            2019-01-28 04:53:26 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                            2019-01-28 11:10:13 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                             2019-01-28 11:57:16 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2019-01-28 13:09:42 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>                                             2019-01-28 19:06:49 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                              2019-01-29 00:29:02 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                               2019-01-29 10:55:52 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                2019-01-29 14:42:37 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                 2019-01-30 03:33:32 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                  2019-01-30 09:56:32 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                   2019-01-30 13:11:01 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                    2019-01-30 14:41:46 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                     2019-01-31 05:36:52 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                      2019-01-31 08:32:01 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                       2019-01-31 12:33:25 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                        2019-02-03 13:06:08 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                         2019-02-03 19:09:14 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                          2019-02-04 03:17:33 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                           2019-02-04 03:54:22 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                            2019-02-04 04:19:30 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                           2019-02-04 04:48:38 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                            2019-02-04 04:59:06 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                             2019-02-04 07:40:53 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                              2019-02-04 08:57:22 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                               2019-02-05 03:04:15 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                2019-02-05 09:55:28 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                                 2019-02-09 12:04:02 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                  2019-02-11 17:18:28 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                                   2019-02-20 11:09:09 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                    2019-02-20 11:34:12 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                                   2019-02-20 12:55:58 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                    2019-02-20 14:38:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                     2019-02-21 03:55:31 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                      2019-02-21 04:35:13 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                       2019-02-21 14:37:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                        2019-02-21 17:37:06 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                         2019-02-22 02:59:27 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                          2019-02-22 15:58:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                          2019-02-22 16:04:06 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                           2019-02-22 23:06:12 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                            2019-02-23 00:02:10 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                          2019-02-23 08:01:11 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                                           2019-02-26 15:20:04 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                            2019-02-26 15:25:42 from Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>                                                                         2019-02-23 07:54:18 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                                          2019-03-07 13:43:18 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                           2019-03-12 02:52:23 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                   2019-02-21 06:58:16 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                    2019-02-21 07:26:25 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                  2019-01-30 17:11:12 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                   2019-01-31 05:41:35 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                    2019-01-31 08:41:56 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                     2019-01-31 12:43:32 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                      2019-01-31 12:52:47 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                       2019-01-31 13:53:44 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> 📎                                                        2019-01-31 15:06:13 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                         2019-01-31 15:47:53 from John Naylor <john(dot)naylor(at)2ndquadrant(dot)com>                                                          2019-02-01 02:30:56 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                    2019-01-31 14:49:15 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                               2019-01-29 11:49:13 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                2019-01-29 12:16:38 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                             2019-02-02 02:00:18 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2019-02-02 12:03:13 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                        2019-01-04 02:57:54 from Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com> 📎                   2018-12-31 03:59:24 from Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>               2018-12-03 05:30:12 from John Naylor <jcnaylor(at)gmail(dot)com>           2018-12-12 21:48:22 from John Naylor <jcnaylor(at)gmail(dot)com> 📎            2018-12-15 05:05:23 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2018-10-16 10:57:25 from John Naylor <jcnaylor(at)gmail(dot)com> 📎      2018-10-16 13:05:28 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: WIP: Avoid creation of the free space map for small tables at 2019-02-20 12:55:58 from Amit Kapila

Responses

• Re: WIP: Avoid creation of the free space map for small tables at 2019-02-21 03:55:31 from Amit Kapila

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Peter Eisentraut	2019-02-20 14:39:21	Remove unnecessary use of PROCEDURAL
Previous Message	Arthur Zakirov	2019-02-20 14:33:44	Re: [PROPOSAL] Shared Ispell dictionaries