From:
"Alex Hunsaker" <badalex(at)gmail(dot)com>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Robert Haas" <robertmhaas(at)gmail(dot)com>, "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Significantly larger toast tables on 8.4?
Date:
2009-01-03 06:16:58
Message-ID:
34d269d40901022216t67941d4x6245033fc5601340@mail.gmail.com (view raw or flat )
Thread:
2009-01-02 04:30:59 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-02 04:49:55 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-02 05:44:49 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-02 06:09:35 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-02 14:57:46 from "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
2009-01-02 16:01:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-02 17:44:38 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-02 18:44:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-02 19:50:34 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-03 01:30:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-03 02:27:46 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-03 09:46:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-01-02 19:42:56 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-02 20:23:13 from "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
2009-01-02 20:35:18 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-02 21:19:00 from "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
2009-01-02 21:43:40 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-03 01:36:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-03 02:37:31 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-03 03:30:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-03 04:34:11 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2009-01-03 05:17:16 from Andrew Chernow <ac(at)esilo(dot)com>
2009-01-03 06:16:58 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-03 22:56:13 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-02 22:48:15 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2009-01-07 14:44:51 from "Gregory Maxwell" <gmaxwell(at)gmail(dot)com>
2009-01-02 20:59:35 from Gregory Stark <stark(at)enterprisedb(dot)com>
2009-01-03 01:46:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-03 06:32:00 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-05 15:57:21 from "Merlin Moncure" <mmoncure(at)gmail(dot)com>
2009-01-03 10:46:53 from "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
2009-01-04 03:47:23 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2009-01-04 04:29:02 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-04 04:56:57 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2009-01-04 05:15:09 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-03 22:45:44 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-04 22:42:05 from James Mansion <james(at)mansionfamily(dot)plus(dot)com>
2009-01-05 01:34:07 from "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
2009-01-05 07:38:21 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-05 16:45:49 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-01-05 16:55:03 from "Merlin Moncure" <mmoncure(at)gmail(dot)com>
2009-01-06 18:10:31 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-06 19:57:41 from "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
2009-01-06 20:30:11 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2009-01-02 18:56:47 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
Lists:
pgsql-hackers
On Fri, Jan 2, 2009 at 20:30, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> One point that nobody seems to have focused on is whether Alex's
> less-compressed table is faster or slower to access than the original.
> I dunno if he has any easy way of investigating that for his typical
> query mix, but it's certainly a fair question to ask.
Other than the quick pgbench numbers I posted upthread where 8.4 blew
8.3 out of the water with a substring. Not really, this table is
mainly insert. A few times a day everything inserted that day gets
selected. So while I'm almost positive 8.4 is faster, its probably
not really noticeable in my workload. That being said here are some
quick numbers:
(see attached q.sql for how uninteresting the query is, also this is
so slow mainly due to the lack of it using an index, it seq-scans the
entire table :()
./pgbench -T600 -n -f q.sql
8.4 with 8.3 TOAST: 6.250298
8.4: 6.460312
(note I dont actually use substring on this table...)
./pgbench -T60 -n -f substring.sql
8.4 w 8.3 TOAST: 12.613394
8.4: 6347.456596
Attachment: q.sql
Description: application/octet-stream (364 bytes)
Attachment: substring.sql
Description: application/octet-stream (99 bytes)
In response to
pgsql-hackers by date
Next :From: Alex HunsakerDate: 2009-01-03 06:32:00Subject : Re: Significantly larger toast tables on 8.4?Previous :From : Andrew ChernowDate : 2009-01-03 05:17:16Subject : Re: Significantly larger toast tables on 8.4?
