PgSql
in [SQL]
|
Small FSM is too large On 20/06/10 13:56, Simon Riggs wrote: I notice that if I vacuum a 1 row table I get a FSM that is 24576 bytes in size, or 3 database blocks. Why is it not 1 block, or better still 0 blocks for such a small table? It was just less code to write and test that way. The FSM tree is always constant height, ... 20 Jun 2010 14:34
stats collector "connection refused" on recv of test message Steve Singer <ssinger_pg(a)sympatico.ca> writes: Is using a single UDP socket structure instance for sending a message to yourself 'proper'? (it looks like we've been doing this in pgstat.c for many years without issues reported). Why wouldn't it be? This machine is a 32bit powerpc running Debian linux... 20 Jun 2010 13:28
[HACKERS] stats collector "connection refused" on recv of test message On one of my machines I get LOG: could not receive test message on socket for statistics collector: Connection refused on startup. I noticed this testing 9.0 but when I went back to check I'm now getting it on 8.3 as well, disabling all of my iptables rules doesn't help. I've done some debugging and th... 20 Jun 2010 13:28
[HACKERS] Small FSM is too large I notice that if I vacuum a 1 row table I get a FSM that is 24576 bytes in size, or 3 database blocks. Why is it not 1 block, or better still 0 blocks for such a small table? -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make ch... 20 Jun 2010 06:58
[HACKERS] beta3 & the open items list It would be nice to get beta3 out the door sooner rather than later, but I sort of feel like we're not ready yet. In fact, we seem to be a bit stalled. The open items list currently lists four items. 1. max_standby_delay. Tom has committed to getting this done, but has been tied up with non-PostgreSQL related ... 19 Jun 2010 13:28
beta3 & the open items list On Sat, 2010-06-19 at 09:43 -0400, Robert Haas wrote: 4. Streaming Replication needs to detect death of master. We need some sort of keep-alive, here. Whether it's at the TCP level (as advocated by Tom Lane and others) or at the protocol level (as advocated by Greg Stark) is something that we have yet t... 28 Jun 2010 05:10
About tapes Il 18/06/2010 21:00, Robert Haas ha scritto: On Fri, Jun 18 Did you read the rest of the comment? It explains how the code avoids this... Robert, thanks for your reply. I read the rest of the document, but please take in account that my question wasn't about "avoiding". My question is "in which ... 21 Jun 2010 15:48
[HACKERS] About tapes Hi to all. Please take a look at the initial comment contained into the logtape.c file: http://doxygen.postgresql.org/logtape_8c-source.html Almost at the beginning of that file, it is affirmed that implementing tapes on disk (quote: /by creating a separate file for each "tape"/) will require more space than... 18 Jun 2010 15:44
extensible enum types On Fri, Jun 18, 2010 at 11:50 AM, Andrew Dunstan <andrew(a)dunslane.net> wrote: Then set the first value at �8 * p, then next at 9* p and so on. This is designed to allow more space to add labels at the beginning and end of the list, where this is more likely. Adding a label would be a matter of finding the l... 23 Jun 2010 19:31
[HACKERS] extensible enum types A recent discussion with a developer convinced me that enums would be much more useful if new values could be added to the label list easily without changing the stored values. Given the current representation of enums as a globally unique oid, I think this is just about impossible if the new label is to go s... 18 Jun 2010 12:26 |