Re: [HACKERS] Confusion over Python drivers {license}

2010-02-10 Thread Greg Smith
their alternative driver a prerequisite for an app I need, only at that point will that driver show back up on my radar. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Confusion over Python drivers {license}

2010-02-10 Thread Greg Smith
completely yet either. For those who feel a true BSD license is vital, I direct you toward http://mailman.vex.net/pipermail/pygresql/2010-February/002315.html to learn more about what direction they could use some help in going. But whatever you do, don't start another project instead. -- Greg

Re: [HACKERS] About psycopg2 (by its author)

2010-02-09 Thread Greg Smith
and your other contributors on that, to make sure everything is accurate and complete. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Confusion over Python drivers

2010-02-08 Thread Greg Smith
situation I feel people are most displeased with. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

2010-02-07 Thread Greg Smith
of discussion has just moved backwards from that point. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Confusion over Python drivers

2010-02-07 Thread Greg Smith
as best I could summarize it: http://wiki.postgresql.org/wiki/Python_PostgreSQL_Driver_TODO Looks like the first action item is to talk with the Psycopg people about their license. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www

Re: [HACKERS] Confusion over Python drivers

2010-02-07 Thread Greg Smith
Greg Smith wrote: Here's a full TODO page that includes everything mentioned here as best I could summarize it: http://wiki.postgresql.org/wiki/Python_PostgreSQL_Driver_TODO Looks like the first action item is to talk with the Psycopg people about their license. Oh: and I'm going to take

Re: [HACKERS] Confusion over Python drivers

2010-02-07 Thread Greg Smith
. link to their mailing list archives or something like that. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Confusion over Python drivers

2010-02-07 Thread Greg Smith
of this work toward the standard libpq routines would seem appropriate for things passing between the driver and libpq. Were the issues you ran into on that side, or more on the Python side of how things were being formatted? -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services

Re: [HACKERS] Confusion over Python drivers

2010-02-06 Thread Greg Smith
-Confirm/add support for the most common standard types (such as array) Any other suggestions before I turn the above into a roadmap page on the wiki? -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- Sent via pgsql

Re: [HACKERS] Confusion over Python drivers

2010-02-05 Thread Greg Smith
of months of regular work to make any serious progress on it. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

2010-02-05 Thread Greg Smith
following through on that implementation would require a major restructuring of how the database interacts with the OS in terms of reads and writes of blocks. It looks to me like doing something similar to sync_file_range on Windows would be similarly difficult. -- Greg Smith 2ndQuadrant US

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Greg Smith
modules generally easier to install are well understood, and many people have been working on potential improvements to that whole situation for a while now. It's a hard problem though. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www

Re: [HACKERS] 64-bit size pgbench

2010-01-29 Thread Greg Smith
available. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Streaming replication, and walsender during recovery

2010-01-28 Thread Greg Smith
, but it's been possible to build something with the same basic feature set since 8.2. Getting that going with a chain of downstreams slaves is not so easy though, so there's something that I think would be unique to the 9.0 implementation. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL

[HACKERS] 64-bit size pgbench

2010-01-28 Thread Greg Smith
pgbench aid | 1 $ psql -x -c select aid from pgbench_accounts order by aid desc limit 1 -d pgbench aid | 5 -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com diff --git a/contrib/pgbench/pgbench.c b/contrib

Re: [HACKERS] WARNING: pgstat wait timeout

2010-01-28 Thread Greg Smith
for something reproducible to gather more info. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Greg Smith
that. You're a few months ahead of me having something written down to share though. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Clustering Docs WAS: Mammoth in Core?

2010-01-27 Thread Greg Smith
Alvaro Herrera wrote: Greg Smith wrote: We've got pgsql-cluster-hackers to discuss this particular area. Huh, is this a new list? It wasn't added to wwwmaster's list of lists, apparently, right? The archives are at http://archives.postgresql.org/pgsql-cluster-hackers/ but it's

Re: [HACKERS] Clustering Docs WAS: Mammoth in Core?

2010-01-27 Thread Greg Smith
Alvaro Herrera wrote: Greg Smith wrote: Alvaro Herrera wrote: Greg Smith wrote: We've got pgsql-cluster-hackers to discuss this particular area. Huh, is this a new list? It wasn't added to wwwmaster's list of lists, apparently, right? The archives

Re: [HACKERS] CommitFest status summary 2010-01-27

2010-01-27 Thread Greg Smith
stretch to me, and I wouldn't consider it very likely that set of work could get finished in time for this CF. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Dividing progress/debug information in pg_standby, and stat before copy

2010-01-26 Thread Greg Smith
this particular job whether or not the community feels it's worthwhile. The only real decision is whether there's enough interest in upgrading this utility to review and possibly commit the result, and I'm trying to minimize the public resources needed even for those parts. -- Greg Smith2ndQuadrant

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

2010-01-26 Thread Greg Smith
is still too long for some people, but it's at least a whole lot better. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.co -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] commit fests

2010-01-25 Thread Greg Smith
into the archives to catch up in a few minutes by following the message ID links. I do that all the time for patches I had previously been ignoring and deleting out of my mailbox. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www

Re: [HACKERS] MySQL-ism help patch for psql

2010-01-25 Thread Greg Smith
-command-equivalents.html http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Clustering Docs WAS: Mammoth in Core?

2010-01-25 Thread Greg Smith
that it is, that work I think is well outside of what this list should be focusing on right now. We've got pgsql-cluster-hackers to discuss this particular area. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

Re: [HACKERS] Dividing progress/debug information in pg_standby, and stat before copy

2010-01-25 Thread Greg Smith
that's outside of the scope of what anyone wants to touch at this point though. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Dividing progress/debug information in pg_standby, and stat before copy

2010-01-25 Thread Greg Smith
in there to make that easy while we're mucking around with all this logging anyway. I'll touch base with you later this week once I've done my initial pass through all this; not sure we need to drag this list through all those details until we've got a unified patch to propose. -- Greg Smith

Re: [HACKERS] Dividing progress/debug information in pg_standby, and stat before copy

2010-01-25 Thread Greg Smith
similar requirements that drive working on it anyway, like Selena it appears, it would be nice to see a final pg_standby get shipped as a result that has less obvious rough parts. Doubt much work will go into it beyond this release though. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL

Re: [HACKERS] commit fests

2010-01-23 Thread Greg Smith
, they're working on the wrong type of project for them. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] HS/SR and smart shutdown

2010-01-21 Thread Greg Smith
this issue. Maybe it's just a change to the beginning of fast shutdown, or to the end of smart as I think you're suggesting. Perhaps you only get it if you do one of these escalating shutdowns I'm proposing, making that the preferred way to handle HS servers. -- Greg Smith2ndQuadrant

Re: [HACKERS] MonetDB test says that PostgreSQL often has errors or missing results

2010-01-20 Thread Greg Smith
, there are others. I'd guess MonetDB followed a procedure just like that, discovered some queries didn't work right, and just called it a day and published rather than investigate. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com

Re: [HACKERS] Mammoth in Core?

2010-01-19 Thread Greg Smith
at the PGCon developer's meeting, most of the action items there came with a clearly labeled person on the hook who was working on them. I don't see any notion like that from this meeting's outcome. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com

Re: [HACKERS] MonetDB test says that PostgreSQL often has errors or missing results

2010-01-19 Thread Greg Smith
was wrong is just shoddy journalism. I'm hoping to have some crow to serve to them about another benchmark result they've published soon, they're back to really rubbing me the wrong way again lately. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g

[HACKERS] Re: [PERFORM] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

2010-01-19 Thread Greg Smith
version of this patch could use at least one more performance checking report that it does something useful. We got a lot of data from Andres, but do we know that the improvements here hold for others too? I can take a look at it later this week, I have some interest in this area. -- Greg

Re: [HACKERS] MonetDB test says that PostgreSQL often has errors or missing results

2010-01-19 Thread Greg Smith
) -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Table size does not include toast size

2010-01-18 Thread Greg Smith
external function to expose it. I don't think there's any useful case for further exposing the two component parts of the toast size. If you're enough of a hacker to know what to do with those, you can certainly break them down yourself. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL

Re: [HACKERS] Table size does not include toast size

2010-01-18 Thread Greg Smith
with to have looked at deeply is exactly how the FSM and toast computations are done, to check if there's any corner cases in how it navigates forks and such that aren't considered. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www

Re: [HACKERS] Clearing global statistics

2010-01-17 Thread Greg Smith
: indexterm primarypg_stat_reset_shared/primary /indexterm I can send an updated patch with both of these things fixed tomorrow. Given that we're talking 5 lines of change here, if it's easier for you to just patch a working copy you've already started on that's fine too. -- Greg Smith

Re: [HACKERS] Streaming replication status

2010-01-15 Thread Greg Smith
Stefan Kaltenbrunner wrote: Greg Smith wrote: The other popular request that keeps popping up here is providing an easy way to see how backlogged the archive_command is, to make it easier to monitor for out of disk errors that might prove catastrophic to replication. I tend to disagree

Re: [HACKERS] Streaming replication status

2010-01-15 Thread Greg Smith
any sense. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Clearing global statistics

2010-01-14 Thread Greg Smith
. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Clearing global statistics

2010-01-14 Thread Greg Smith
Euler Taveira de Oliveira wrote: Greg Smith escreveu: pg_stat_reset( which text ) which := 'buffers' | 'checkpoints' | 'tables' | 'functions' | ... What about adding 'all' too? Or the idea is resetting all global counters when we call pg_stat_reset() (without parameters

Re: [HACKERS] Clearing global statistics

2010-01-14 Thread Greg Smith
that better, but I've found it hard to justify working on given that it's not that difficult to handle outside of the database once the individual pieces are exposed. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

Re: [HACKERS] Clearing global statistics

2010-01-14 Thread Greg Smith
, in the form of a tool much more likely to be used correctly by people who go looking for it than misused IMHO. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Clearing global statistics

2010-01-14 Thread Greg Smith
checked during message creation. That seems consistent with the other code here--the other message handlers only seem to throw errors when something really terrible happens, not when they just don't find something useful to do. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training

Re: [HACKERS] plpython3

2010-01-14 Thread Greg Smith
had read the documentation before so it wasn't that bad that I couldn't see it. Basically, the issue I had is that it's not really clear which features are unique to this implementation that make it compelling. So more targeted examples like you're considering now would help. -- Greg Smith

Re: [HACKERS] Streaming replication status

2010-01-14 Thread Greg Smith
to be more complicated because it requires passing more information into the archiver, with little gain for that work beyond improving the quality of this diagnostic routine. And I think most people would find what I described above useful enough. -- Greg Smith2ndQuadrant Baltimore, MD

Re: [HACKERS] Streaming replication status

2010-01-13 Thread Greg Smith
to identify that segment file on disk, you can always look at its timestamp (and the ones on the rest of the files in that directory) in a monitoring script to turn that information into segments or a time measurement instead--xlog segments are nicely ordered after all. -- Greg Smith2ndQuadrant

Re: [HACKERS] [PATCH] remove redundant ownership checks

2010-01-13 Thread Greg Smith
this discussion, because previous patches were just too big. We do need to get this whole thing off the list for a while now though, I think it's gotten quite a fair slice of discussion already. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com

Re: [HACKERS] plpython3

2010-01-13 Thread Greg Smith
of examples that, while still complicated, are completely self-contained and possible to follow along until you understand how it all fits together. Patch submitters should consider it a goal to make life that easy for the reviewer stuck with checking their patch out. -- Greg Smith2ndQuadrant

Re: [HACKERS] Streaming replication status

2010-01-12 Thread Greg Smith
Heikki Linnakangas wrote: Greg Smith wrote: I don't think anybody can deploy this feature without at least some very basic monitoring here. I like the basic proposal you made back in September for adding a pg_standbys_xlog_location to replace what you have to get from ps right now: http

Re: [HACKERS] Clearing global statistics

2010-01-12 Thread Greg Smith
patch to do that? -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Streaming replication status

2010-01-12 Thread Greg Smith
), and certainly the ideas thrown out for implementing any smart behavior or alerting when replication goes bad like Josh's archiving_lag_action seem based the deadline to get addressed now--even though I agree with the basic idea. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training

Re: [HACKERS] damage control mode

2010-01-11 Thread Greg Smith
in between now and release time.) -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Streaming replication status

2010-01-11 Thread Greg Smith
a pg_standbys_xlog_location to replace what you have to get from ps right now: http://archives.postgresql.org/pgsql-hackers/2009-09/msg00889.php That's basic, but enough that people could get by for a V1. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g

Re: [HACKERS] Streaming replication status

2010-01-11 Thread Greg Smith
but a very narrow use case? -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

Re: [HACKERS] Add .gitignore files to CVS?

2010-01-09 Thread Greg Smith
Peter Eisentraut wrote: Probably someone to actually track the open items that are mentioned every time this discussion happens. http://wiki.postgresql.org/wiki/Switching_PostgreSQL_from_CVS_to_Git now has what I believe the state of the world to be in this area. -- Greg Smith

Re: [HACKERS] git help

2010-01-08 Thread Greg Smith
matter at the end. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] damage control mode

2010-01-07 Thread Greg Smith
is more fair than not getting that author's patch a review at all, right? So why bounce them prematurely? -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Testing with concurrent sessions

2010-01-06 Thread Greg Smith
when finished. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Setting oom_adj on linux?

2010-01-04 Thread Greg Smith
the purpose of the change, I'm not sure what the benefit there is--if you have to turn it on, you might as well do something at a higher level instead. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

Re: [HACKERS] Thoughts on statistics for continuously advancing columns

2009-12-30 Thread Greg Smith
of plans you get. Once there's millions of distinct values it's takes a big change for plans to shift, etc. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] Thread safety and libxml2

2009-12-30 Thread Greg Smith
. It seems quite likely to bite someone else again the future. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Thoughts on statistics for continuously advancing columns

2009-12-30 Thread Greg Smith
is much faster than the logical end doesn't help either. I should generate that graph again one day somewhere I can release it at... -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing

Re: [HACKERS] parse tree to XML format

2009-12-29 Thread Greg Smith
what wandering down this path will accomplish for you though. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [PERFORM] [HACKERS] Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

2009-12-28 Thread Greg Smith
://www.westnet.com/~gsmith/content/linux-pdflush.htm It would be interesting to graph the Dirty and Writeback figures in /proc/meminfo over time with and without this patch in place. That should make it obvious what the kernel is doing differently in the two cases. -- Greg Smith2ndQuadrant Baltimore

Re: [HACKERS] Table size does not include toast size

2009-12-21 Thread Greg Smith
of the database. However, the documentation should be updated to warn against the issue with TOAST here. And it should be easier to get the total you're like to see here: main relation + toasted parts, since that's what most DBAs want in this area. -- Greg Smith2ndQuadrant Baltimore, MD

Re: [HACKERS] Table size does not include toast size

2009-12-21 Thread Greg Smith
for table. Bernd, there's a basic spec if you have time to work on this. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Backup history file should be replicated in Streaming Replication?

2009-12-19 Thread Greg Smith
on tweaking the smaller details here is larger than those capable of working on the fundamental streaming replication code. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Closing out CommitFest 2009-11

2009-12-18 Thread Greg Smith
On Tue, Dec 15, 2009 Greg Smith wrote: Sounds like we just are waiting for Simon to finish up, which is expected to happen by tomorrow, and for Tom to wrap up working on the ProcessUtility_hook. That makes the first reasonable date to consider alpha3 packaging Thursday 12/17 I think. Update

Re: [HACKERS] new CommitFest states

2009-12-18 Thread Greg Smith
Robert Haas wrote: On Mon, Dec 14, 2009 at 12:38 PM, Greg Smith g...@2ndquadrant.com wrote: Robert Haas wrote: I don't think there should be a transition from Returned with Feedback back to Waiting for review. Granted we might allow that occasionally as an exceptional case

Re: [HACKERS] Closing out CommitFest 2009-11

2009-12-18 Thread Greg Smith
after them (at the expense of postponing the beta) left for this release. Just figured I'd pass along that warning before somebody discovers it the hard way, by working madly to finish their submission up only to see it get kicked to the next version anyway. -- Greg Smith2ndQuadrant

Re: [HACKERS] PostgreSQL project policy compendium

2009-12-16 Thread Greg Smith
://wiki.postgresql.org/wiki/Developer_FAQ and http://wiki.postgresql.org/wiki/Submitting_a_Patch are what we've got now. There's a number of us who try to record any interesting discussion bits like this one into one of those, to shorten the future learning curve for others. -- Greg Smith

Re: [HACKERS] [patch] executor and slru dtrace probes

2009-12-15 Thread Greg Smith
based on its submission date. You're not really getting a fair chunk of time here between your review and the end here because of problems lining up reviewer time, that shouldn't happen next time. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g

[HACKERS] Closing out CommitFest 2009-11

2009-12-15 Thread Greg Smith
obviously keep working on them as he gets time. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Closing out CommitFest 2009-11

2009-12-15 Thread Greg Smith
Robert Haas wrote: On Tue, Dec 15, 2009 at 12:27 PM, Greg Smith g...@2ndquadrant.com wrote: -New VACUUM FULL I get the impression there is still some discussion that needs to happen about the design of this. I think we should mark it Returned with Feedback for now, and let whoever

Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?

2009-12-14 Thread Greg Smith
; pgadmin-support was the right place for it: http://archives.postgresql.org/pgadmin-support/ -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] new CommitFest states

2009-12-14 Thread Greg Smith
realizing what was missing. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

Re: [HACKERS] Hot Standby, release candidate?

2009-12-14 Thread Greg Smith
into? -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] new CommitFest states

2009-12-14 Thread Greg Smith
is tightly bounded as far as how much time the author has to do it. (Also, Waiting for review is actually the wrong name for the state it's trying to talk about.) Uh, what are you talking about here? -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-14 Thread Greg Smith
. This feature is only really useful as far as performance testing goes if you're using it on an I/O bound test. I have some more pgbench hints to apply at some point in the future, so it wouldn't be problem to skip this for now; I can bundle it into that section later. -- Greg Smith2ndQuadrant

Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?

2009-12-14 Thread Greg Smith
know, we can try to keep someone else from being confused and instead directed to the right place more directly. It would be a nice gesture on your part to end our conversation here having done something useful, rather than with you just venting at me. -- Greg Smith2ndQuadrant Baltimore

Re: [HACKERS] pgbench: new feature allowing to launch shell commands

2009-12-14 Thread Greg Smith
dragging things out further into new territory. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] XLogInsert

2009-12-14 Thread Greg Smith
. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Hot Standby, release candidate?

2009-12-14 Thread Greg Smith
. And on the PR side, announcing HS as hitting core and available in the alpha is huge. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

Re: [HACKERS] new CommitFest states

2009-12-12 Thread Greg Smith
listed here is pretty obvious working from this table. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] SE-PostgreSQL/Lite Review

2009-12-11 Thread Greg Smith
regularly just because of tab/space issues, and I know I run into one of those nearly every CommitFest. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] thread safety on clients

2009-12-11 Thread Greg Smith
of that code path. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Adding support for SE-Linux security

2009-12-11 Thread Greg Smith
problem that might be a recurring one. It would be nice if we could all get better at identifying when it does happen, and perhaps find someone to help with planning before we waste so much time chasing code that isn't going to be accepted yet again. -- Greg Smith2ndQuadrant Baltimore, MD

Re: [HACKERS] [PATCH] dtrace probes for memory manager

2009-12-11 Thread Greg Smith
, you're using a debugger to track your leak down only after reproducing a test case for it. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Adding support for SE-Linux security

2009-12-11 Thread Greg Smith
at http://wiki.postgresql.org/wiki/Hot_Standby shows a reasonable way to organize such a thing from a similarly complicated patch. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing

Re: [HACKERS] EXPLAIN BUFFERS

2009-12-10 Thread Greg Smith
about everywhere else already, right? -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[HACKERS] SE-PostgreSQL/Lite Review

2009-12-10 Thread Greg Smith
into the middle of this area regularly anyway. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] CommitFest 2009-11: Reviews complete

2009-12-10 Thread Greg Smith
. It certainly feels to me like the average quality of patches making their way through to our committers keeps itching upwards, so they spend less time fighting things like patch bit-rot and stuff that just plain doesn't work, and more time doing serious review work. -- Greg Smith

Re: [HACKERS] thread safety on clients

2009-12-10 Thread Greg Smith
the wrong thing and operating in an unsafe way after the recent change is what Peter's suggesting. This is good, actually, because I don't think we had many client-side thread-safety tests floating around to catch problems in this area before. -- Greg Smith2ndQuadrant Baltimore, MD

Re: [HACKERS] Adding support for SE-Linux security

2009-12-10 Thread Greg Smith
be others in there too. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] SE-PostgreSQL/Lite Review

2009-12-10 Thread Greg Smith
Stephen Frost wrote: * Greg Smith (g...@2ndquadrant.com) wrote: I have to be honest and say that I'm not optimistic that this is possible or even a good idea to accomplish in the time remaining during this release. While I agree with you, I wish you hadn't brought it up

Re: [HACKERS] Adding support for SE-Linux security

2009-12-10 Thread Greg Smith
So it's not without value even in its current Lite form. But there's clearly a whole lot more use-cases that would benefit from a version with row filtering. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent

Re: [HACKERS] XLogInsert

2009-12-09 Thread Greg Smith
. -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com

<    5   6   7   8   9   10   11   12   13   14   >