On 16/09/13 16:20, Satoshi Nagayasu wrote:
Thanks for checking. Fixed to eliminate SnapshotNow.
Looking forward to get a new patch, incorporating the comments, that are
already given in the following mails:
1. Jaime Casanova: The name pgstattuple2, doesn't convince me... maybe you can
use
On 16/09/13 16:20, Satoshi Nagayasu wrote:
Thanks for checking. Fixed to eliminate SnapshotNow.
Looking forward to get a new patch, incorporating the comments, that are
already given in the following mails:
1. Jaime Casanova: The name pgstattuple2, doesn't convince me... maybe you can
use
On 16/10/13 11:51, Mark Kirkwood wrote:
On 11/10/13 17:33, Jaime Casanova wrote:
also the name pgstattuple2, doesn't convince me... maybe you can use
pgstattuple() if you use a second argument (percentage of the sample)
to overload the function
+1, that seems much nicer.
Oh - and if you
On 11/10/13 17:49, Mark Kirkwood wrote:
On 11/10/13 17:08, Satoshi Nagayasu wrote:
(2013/10/11 7:32), Mark Kirkwood wrote:
On 11/10/13 11:09, Mark Kirkwood wrote:
On 16/09/13 16:20, Satoshi Nagayasu wrote:
(2013/09/15 11:07), Peter Eisentraut wrote:
On Sat, 2013-09-14 at 16:18 +0900, Satoshi
On 11/10/13 17:33, Jaime Casanova wrote:
also the name pgstattuple2, doesn't convince me... maybe you can use
pgstattuple() if you use a second argument (percentage of the sample)
to overload the function
+1, that seems much nicer.
Regards
Mark
--
Sent via pgsql-hackers mailing list
On 16/09/13 16:20, Satoshi Nagayasu wrote:
(2013/09/15 11:07), Peter Eisentraut wrote:
On Sat, 2013-09-14 at 16:18 +0900, Satoshi Nagayasu wrote:
I'm looking forward to seeing more feedback on this approach,
in terms of design and performance improvement.
So, I have submitted this for the
On 11/10/13 11:09, Mark Kirkwood wrote:
On 16/09/13 16:20, Satoshi Nagayasu wrote:
(2013/09/15 11:07), Peter Eisentraut wrote:
On Sat, 2013-09-14 at 16:18 +0900, Satoshi Nagayasu wrote:
I'm looking forward to seeing more feedback on this approach,
in terms of design and performance
(2013/10/11 7:32), Mark Kirkwood wrote:
On 11/10/13 11:09, Mark Kirkwood wrote:
On 16/09/13 16:20, Satoshi Nagayasu wrote:
(2013/09/15 11:07), Peter Eisentraut wrote:
On Sat, 2013-09-14 at 16:18 +0900, Satoshi Nagayasu wrote:
I'm looking forward to seeing more feedback on this approach,
in
On Thu, Oct 10, 2013 at 5:32 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
Quietly replying to myself - looking at the code the sampler does 3000
random page reads...
FWIW, something that bothers me is that there is 3000 random page
reads... i mean, why 3000? how do you get that
On 11/10/13 17:08, Satoshi Nagayasu wrote:
(2013/10/11 7:32), Mark Kirkwood wrote:
On 11/10/13 11:09, Mark Kirkwood wrote:
On 16/09/13 16:20, Satoshi Nagayasu wrote:
(2013/09/15 11:07), Peter Eisentraut wrote:
On Sat, 2013-09-14 at 16:18 +0900, Satoshi Nagayasu wrote:
I'm looking forward to
On 11/10/13 17:33, Jaime Casanova wrote:
On Thu, Oct 10, 2013 at 5:32 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
Quietly replying to myself - looking at the code the sampler does 3000
random page reads...
FWIW, something that bothers me is that there is 3000 random page
reads... i
(2013/09/15 11:07), Peter Eisentraut wrote:
On Sat, 2013-09-14 at 16:18 +0900, Satoshi Nagayasu wrote:
I'm looking forward to seeing more feedback on this approach,
in terms of design and performance improvement.
So, I have submitted this for the next CF.
Your patch fails to build:
(2013/07/23 20:02), Greg Smith wrote:
On 7/23/13 2:16 AM, Satoshi Nagayasu wrote:
I've been working on new pgstattuple function to allow
block sampling [1] in order to reduce block reads while
scanning a table. A PoC patch is attached.
Take a look at all of the messages linked in
On Sat, 2013-09-14 at 16:18 +0900, Satoshi Nagayasu wrote:
I'm looking forward to seeing more feedback on this approach,
in terms of design and performance improvement.
So, I have submitted this for the next CF.
Your patch fails to build:
pgstattuple.c: In function ‘pgstat_heap_sample’:
Hi,
I've been working on new pgstattuple function to allow
block sampling [1] in order to reduce block reads while
scanning a table. A PoC patch is attached.
[1] Re: [RFC] pgstattuple/pgstatindex enhancement
On 7/23/13 2:16 AM, Satoshi Nagayasu wrote:
I've been working on new pgstattuple function to allow
block sampling [1] in order to reduce block reads while
scanning a table. A PoC patch is attached.
Take a look at all of the messages linked in
16 matches
Mail list logo
