[HACKERS] Checkpoint sync pause

2012-01-15 Thread Greg Smith
) added, 0 removed, 0 recycled; write=2.422 s, sync=13.282 s, total=16.123 s; sync files=36, longest=1.085 s, average=0.040 s No docs yet, really need a better guide to tuning checkpoints as they exist now before there's a place to attach a discussion of this to. -- Greg Smith 2ndQuadrant

Re: [HACKERS] xlog location arithmetic

2012-01-14 Thread Greg Smith
helpful to reviewers and committers. And the easiest way to keep up with that is to start as early as possible: add it to the app right after the first patch submission. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www

Re: [HACKERS] Why is CF 2011-11 still listed as In Progress?

2012-01-14 Thread Greg Smith
On 01/09/2012 09:56 PM, Greg Smith wrote: The main question still lingering about is the viability of pushing out an 9.2alpha3 at this point. That was originally scheduled for December 20th. There was a whole lot of active code whacking still in progress that week though. And as soon

Re: [HACKERS] automating CF submissions (was xlog location arithmetic)

2012-01-14 Thread Greg Smith
the recent e-mail messages for an existing submission, such that you could just click on the ones that you wanted added to the patch's e-mail history, would save me personally enough time that I could probably even justify writing it. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com

Re: [HACKERS] pgbench post-connection command

2012-01-13 Thread Greg Smith
blocked with you can already do that setting PGxxx before calling pgbench. That is true, but not obvious, and periodically it get reinvented again. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent

Re: [HACKERS] Postgres ReviewFest Patch: URI connection string support for libpq

2012-01-13 Thread Greg Smith
expect everyone to know because it isn't one of the popular pages to read. I've sorted out the problem for this one already, just letting whoever made that change know about the process here. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services

Re: [HACKERS] Patch to allow users to kill their own queries

2012-01-13 Thread Greg Smith
. Bounced forward to the next CommitFest and back on my plate again. Guess I'll be learning new and exciting things about translation this week. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql

[HACKERS] Speed dblink using alternate libpq tuple storage

2012-01-13 Thread Greg Smith
. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com diff --git a/contrib/dblink/dblink.c b/contrib/dblink/dblink.c index 36a8e3e..f48fe4f 100644 *** a/contrib/dblink/dblink.c --- b/contrib/dblink/dblink.c

Re: [HACKERS] checkpoint writeback via sync_file_range

2012-01-12 Thread Greg Smith
the OS a bit more room to move around than fsync does, making the potential for a latency gain here seem quite real. We'll see how the benchmarking goes. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

Re: [HACKERS] checkpoint writeback via sync_file_range

2012-01-11 Thread Greg Smith
queue more aggressively should make the eventual fsync less likely to block. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] checkpoint writeback via sync_file_range

2012-01-11 Thread Greg Smith
. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support 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] random_page_cost vs seq_page_cost

2012-01-10 Thread Greg Smith
on what to collect. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support 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] pgsphere

2012-01-10 Thread Greg Smith
://wiki.postgresql.org/wiki/Project_Hosting has started a small migration guide of sorts for where else you might host this sort of project at. It's not necessarily obvious what pgfoundry provides relative to other sites, or what the trade-offs in the other possibilities are. -- Greg Smith

Re: [HACKERS] checkpoint writeback via sync_file_range

2012-01-10 Thread Greg Smith
sure what a good test setup would look like either, so while I've tested that this appears to issue the right kernel calls, I am not sure whether it actually fixes the problem case. I'll put this into my testing queue after the upcoming CF starts. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] Why is CF 2011-11 still listed as In Progress?

2012-01-09 Thread Greg Smith
not too many new things for people to be excited about trying. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] WIP(!) Double Writes

2012-01-09 Thread Greg Smith
battle to prove any performance gains you've been seeing will still happen in the current 9.2 code. Performance for that version has advanced even further forward in ways 9.0 can't emulate. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services

Re: [HACKERS] 16-bit page checksums for 9.2

2012-01-09 Thread Greg Smith
approach. If you accept that sort of utility is inevitable, you might as well presume it could handle this sort of task eventually too. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql

Re: [HACKERS] 16-bit page checksums for 9.2

2012-01-09 Thread Greg Smith
mentioning both extremes of that: http://www.mysqlperformanceblog.com/2006/08/04/innodb-double-write/ http://www.bigdbahead.com/?p=392 Makes me wish I knew off the top of my head how expensive WAL logging hint bits would be, for comparison sake. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] our buffer replacement strategy is kind of lame

2012-01-05 Thread Greg Smith
. Then it should realize a burst is here and the writer has to start moving faster. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Page Checksums

2011-12-21 Thread Greg Smith
is being steered by engineers who work at Oracle. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Page Checksums

2011-12-20 Thread Greg Smith
suggested would sometimes kick out an automatic fix. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] archive_keepalive_command

2011-12-19 Thread Greg Smith
the last of the reasons I was speculating on for adding more timestamps into the WAL stream. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Command Triggers

2011-12-19 Thread Greg Smith
for writing new such tool much lower. And the construction of a better API for output benefited from seeing what people had actually been struggling with before then. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-19 Thread Greg Smith
to live with is a commit of this where the hint goes away completely. It's taken a long time chopping the specification to get this feature sorted out; we might as well make what's left be the best it can be now. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL

Re: [HACKERS] review: CHECK FUNCTION statement

2011-12-19 Thread Greg Smith
better. I was guessing you had a large body of such source code around, and knowing it executed correctly against all of it improves my confidence here. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

Re: [HACKERS] Command Triggers

2011-12-19 Thread Greg Smith
releases. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] Page Checksums

2011-12-19 Thread Greg Smith
tip of a mostly underwater iceburg. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2011-12-19 Thread Greg Smith
comments from Robert and Tom. Given how these are structured, is fdw_helper_funcs_v3.patch at the point where it should be considered for committer review? Maybe pgsql_fdw_v5.patch too? The others seem to be more in flux to me, due to all the recent pushdown changes. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] why do we need two snapshots per query?

2011-12-19 Thread Greg Smith
wheel by committing it himself. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Page Checksums

2011-12-19 Thread Greg Smith
A, Stored CRC B; error raised because A!=B Standby: Computed CRC C, Stored CRC D If C==D A==C, the corruption is probably overwritten bits of the CRC B. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-16 Thread Greg Smith
to notice, not enough to see anything worth doing about it. Maybe that's just wasted lines of text? With so little grief on the last round, I'm going to guess this one will just get picked up by Magnus to commit next. Marking accordingly and moved to the current CommitFest. -- Greg Smith

Re: [HACKERS] foreign key locks, 2nd attempt

2011-12-16 Thread Greg Smith
it returned with feedback for now. I'm trying to remove everything that isn't likely to end up in the next alpha from the open list. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-16 Thread Greg Smith
access to launch this sort of attack, I think I'd find mayhem elsewhere more a more profitable effort. Crazy queries, work_mem abuse, massive temp file generation, trying to get the OOM killer involved; seems like there's bigger holes than this already. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] [PATCH] Caching for stable expressions with constant arguments v3

2011-12-16 Thread Greg Smith
this is going to reach ready to commit in the next few days though, so I'm going to mark it as returned for this CommitFest. The results you're showing are quite interesting, perhaps someone can help sorting out the parsing area that's accidentally being decelerated. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

2011-12-16 Thread Greg Smith
leave this one to his watch now. If it does turn out to be committed soon instead of re-submitted as I'm presuming right now, I can always go back and fix that. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www

Re: [HACKERS] Prep object creation hooks, and related sepgsql updates

2011-12-16 Thread Greg Smith
it in the CF app accordingly. Note that these were labeled as proof-of-concept in the original submission, so a commit might not be the right next step even if they look good so far. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7

Re: [HACKERS] Review: Non-inheritable check constraints

2011-12-16 Thread Greg Smith
-inheritable from this moment on with that new local definition? With this open question, this looks like it's back in Alvaro's hands again to me. This one started the CF as Ready for Committer and seems stalled there for now. I'm not going to touch its status, just pointing this fact out. -- Greg

Re: [HACKERS] review: CHECK FUNCTION statement

2011-12-16 Thread Greg Smith
think it justs a bit more time than we have left in this CommitFest for it right now, particularly given the size of the patch. I'm turning this one into returned with feedback, but as a mediocre pl/pgsql author I'm hoping to see more updates still. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] patch for type privileges

2011-12-16 Thread Greg Smith
be ready for commit (and an Open Items link toward the do later?) I'm going to mark this one returned with feedback on the assumption there is still some refactoring going on here though; can always change it if Peter sprints back with a commit candidate. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] Allow substitute allocators for PGresult.

2011-12-16 Thread Greg Smith
to see if anyone wants to take a look at it, now that it seems to be in good enough shape to deliver measurable results. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list

Re: GiST for range types (was Re: [HACKERS] Range Types - typo + NULL string constructor)

2011-12-16 Thread Greg Smith
this down. You might also describe what it is you're looking for better and see if anyone else has a suggestion. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

Re: [HACKERS] pg_restore --no-post-data and --post-data-only

2011-12-16 Thread Greg Smith
or have someone else take a last look over it instead. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Inlining comparators as a performance optimisation

2011-12-16 Thread Greg Smith
for the current CommitFest. Marking it returned and we'll return to this topic during or before the next CF. With the majority of the comments here coming from committers, I think continuing progress in that direction won't be a problem. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com

Re: [HACKERS] CommitFest 2011-11 Update

2011-12-16 Thread Greg Smith
Simon pair seem to add up to something that addresses the concerns I raised about computations from a single system and differences between transaction and WAL timing. I'm finding myself on the hook for this area, so I'll try myself to help keep it from stalling again. -- Greg Smith

Re: [HACKERS] includeifexists in configuration file

2011-12-15 Thread Greg Smith
: database system is ready to accept connections -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index d1e628f..0cc3296 100644 *** a/doc/src

Re: [HACKERS] IDLE in transaction introspection

2011-12-15 Thread Greg Smith
possibly committing the result. I think we can make this one returned with feedback for this CF, but encourage Scott to resubmit as early as feasible before the next one. With some good luck, we might even close this out before that one even starts. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] Measuring relation free space

2011-12-15 Thread Greg Smith
On 11/28/2011 05:40 AM, Greg Smith wrote: Ignoring fillfactor seems to have even more downsides as I see it. Certainly deserves a doc improvement, as well as fixing the description of the value so it's clearly a ratio rather than a true percentage. So: I'm very clear on what to do here now

Re: [HACKERS] patch : Allow toast tables to be moved to a different tablespace

2011-12-15 Thread Greg Smith
it returned with feedback for now. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] includeifexists in configuration file

2011-12-15 Thread Greg Smith
it in the recovery.conf thread. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-15 Thread Greg Smith
is that you wouldn't want to do something like grab a PID, vacuum a table, and then assume that PID was still valid. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Measuring relation free space

2011-12-15 Thread Greg Smith
of the table or index is cached, so isolating that out will be a pain. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] [PATCH] Caching for stable expressions with constant arguments v3

2011-12-15 Thread Greg Smith
of the first questions I have is whether the performance changed between there and your v5. A self-contained and fully automated performance test case would ease review, and give some performance regression testing for other suggested changes to use as a reference. -- Greg Smith 2ndQuadrant

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-14 Thread Greg Smith
. I'll refactor to do that, tweak the hint message, and resubmit. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-12-14 Thread Greg Smith
, is doomed regardless of what we do to try and help them.) -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-12-14 Thread Greg Smith
to provide that cleaner UI, but can pick up enough agreement that backward compatibility limited to the sort of migration ideas I outlined is acceptable, I'd be happy with that progress. Hopes of reaching that point is the reason I dumped time into those alternative include options. -- Greg Smith

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-12-14 Thread Greg Smith
that people can assemble the setup they'd like out of the available parts, Maybe these slightly different semantics between archive recovery and standby mode are exactly why they should be kicked off by differently named files? -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-12-14 Thread Greg Smith
promised benefits are proven first though. And I'm thinking a release doing all that is going to want to be named 10.0--and what I could really use is a nice, solid 9.2 that doesn't scare enterprises with too much change next. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-13 Thread Greg Smith
to address that. It might drift back toward something closer to Josh's original design. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index e7f7fe0

Re: [HACKERS] Command Triggers

2011-12-13 Thread Greg Smith
of the system instead. I know what I was just rallying against is not what you were arguing for, you just triggered a stored rant of mine. [Bad trigger joke goes here] Regardless, thoughts on where the holes are here are appreciated. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore

Re: [HACKERS] JSON for PG 9.2

2011-12-13 Thread Greg Smith
http://wiki.postgresql.org/wiki/JSON_datatype_GSoC_2010 too. I don't think it's completely stuck in a cycle yet--every pass around seems to accumulate some better informed ideas than the last still. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training

Re: [HACKERS] JSON for PG 9.2

2011-12-13 Thread Greg Smith
is orders of magnitude larger than the current PostgreSQL community. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] LibreOffice driver 1: Building libpq with Mozilla LDAP instead of OpenLDAP

2011-12-13 Thread Greg Smith
. This is less controversial. If you yell at Tom about something messy that must be done only to support Windows and Mac OS X, he does something completely different with his RedHat Fedora. It's kind of like http://www.youtube.com/watch?v=kLbOMb7F40k , only more red. -- Greg Smith

Re: [HACKERS] LibreOffice driver 2: MIT Kerberos vs Microsoft Kerberos

2011-12-13 Thread Greg Smith
security issues of pulling that in at this point. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Command Triggers

2011-12-13 Thread Greg Smith
behind the Wikipedia link, and ahead of the FreeBSD, Chromium, Apache, and Mozilla pages on that topic. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] logging in high performance systems.

2011-12-13 Thread Greg Smith
like to attend, it's a week from today. (Note that the NYC PUG is also having its meeting at the same time this month) -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing

Re: [HACKERS] Configuration include directory

2011-12-13 Thread Greg Smith
comparison with Apache in regards to how parts of the pg_hba.conf are configured. No argument here that I need to clean that section up still if I'm going to make this argument though. I didn't expect to throw out 85 new lines of docs and get them perfect the first time. -- Greg Smith

Re: [HACKERS] Configuration include directory

2011-12-13 Thread Greg Smith
the highlights: http://archives.postgresql.org/pgsql-hackers/2009-10/msg01628.php -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] WIP: URI connection string support for libpq

2011-12-13 Thread Greg Smith
no one has ever paid me enough to stomach writing non-trivial things in Perl. Perhaps you are more diverse. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us diff --git a/src/interfaces/libpq/fe-connect.c b

Re: [HACKERS] WIP: URI connection string support for libpq

2011-12-13 Thread Greg Smith
anymore even even for me. As for the rest of the world, I direct you toward https://github.com/erh/mongo-jdbc as a sign of the times. experimental because there's not much demand for JDBC in web app land anymore. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD

Re: [HACKERS] Configuration include directory

2011-12-12 Thread Greg Smith
received too many past beatings toward using the string variants of all these functions whenever operating on things that are clearly strings. I'll punt this one toward whoever looks at this next to decide, both strcmp and strncmp are used in this section now. -- Greg Smith 2ndQuadrant US

Re: [HACKERS] Configuration include directory

2011-12-12 Thread Greg Smith
On 12/12/2011 01:34 PM, Greg Smith wrote: You can see a snapshot of the new doc page I built at http://http://www.westnet.com/~gsmith/config-setting.html One minute past send note on brain fade: this section include '00shared.conf' include '01memory.conf' include '02server.conf

Re: [HACKERS] includeifexists in configuration file

2011-12-12 Thread Greg Smith
getting a review for. I'll update this with the name change and appropriate rebased patch once some decision has been made about that one; will just bounce this forward to January if it's still here when the current CF starts closing in earnest. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] [REVIEW] pg_last_xact_insert_timestamp

2011-12-12 Thread Greg Smith
to navigate though to compute master-cascaded standby lag. Cascade the WALSender timestamps instead, which seems pretty simple to do, and then people can just ask their local standby. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7

Re: [HACKERS] pg_cancel_backend by non-superuser

2011-12-12 Thread Greg Smith
to you. As I said, you did at least make a good first impression, and that is worth something when it comes to this group. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing

Re: [HACKERS] [REVIEW] pg_last_xact_insert_timestamp

2011-12-10 Thread Greg Smith
out lag from there. Window function query + constantly churning monitoring table=high overhead. It would really be great to EOL that whole messy section as deprecated starting in 9.2. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7

Re: GiST for range types (was Re: [HACKERS] Range Types - typo + NULL string constructor)

2011-12-10 Thread Greg Smith
entry -Subdiff issues The third one sounded hard to deal with, so presumably nothing there. I'm not sure if your updated rebase addresses either of those first two yet or not, or if it was just fixing bitrot from upstream code changes. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com

Re: [HACKERS] [PATCH] Caching for stable expressions with constant arguments v3

2011-12-10 Thread Greg Smith
to play with the program. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] %TYPE and array declaration patch review

2011-12-10 Thread Greg Smith
. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- 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] pg_cancel_backend by non-superuser

2011-12-10 Thread Greg Smith
different people wanted same-user cancels (or more) badly enough to submit a patch adding it, in three cases now. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql

[HACKERS] CommitFest 2011-11 Update

2011-12-10 Thread Greg Smith
suspects responsible for a good chunk of them. Greg Smith: 10 patches that troublemaker is meddling with in some form. I'm clearly not going anywhere this upcoming week, as I've had panic over closing of CommitFest in the middle of December on my calendar for a while. General plan of attack

Re: [HACKERS] Review of VS 2010 support patches

2011-12-10 Thread Greg Smith
forward and do it themselves. I'm going to mark this one returned with feedback for now. So long as we get an update from you before the January 15th CommitFest, this should still be feasible to slip into 9.2. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL

Re: [HACKERS] Timing overhead and Linux clock sources

2011-12-09 Thread Greg Smith
0.00336% 8: 1741 0.06493% 4: 2062 0.07690% 2:2260601 84.30489% 1: 416954 15.54952% 0: 0 0.0% This seems to be measuring exactly the problem I only had a hand-wave it's bad on this hardware explanation of before. -- Greg

Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2011-12-09 Thread Greg Smith
on that. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Configuration include directory

2011-12-07 Thread Greg Smith
anything has broken that part; I did glance at it. Since I have a pile of good feedback from Noah now, I'll specifically test this as part of submitting the next patch update. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support

[HACKERS] Timing overhead and Linux clock sources

2011-12-06 Thread Greg Smith
Time: 2.920 ms Time: 2.862 ms Time: 2.856 ms That's more like it. Next up I plan to survey a few AMD systems and a newer laptop, but I'm out of time for this tonight. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www

Re: [HACKERS] Timing overhead and Linux clock sources

2011-12-06 Thread Greg Smith
for that process to do, when it's decoupled from doing the checkpoint sync job so its worst-case response time is expected to tighten up. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers

Re: [HACKERS] [PATCH] optional cleaning queries stored in pg_stat_statements

2011-12-01 Thread Greg Smith
is the better route forward, the much higher complexity level does mean it's surely possible for it to be rejected. We have a reviewer signed up for Peter's submission now; I think what to do with Tomas's entry will be an easier to make once that report is in. -- Greg Smith 2ndQuadrant USg

Re: [HACKERS] Patch to allow users to kill their own queries

2011-12-01 Thread Greg Smith
testing run tomorrow. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Word-smithing doc changes

2011-11-30 Thread Greg Smith
Excerpts from Greg Stark's message of sáb jun 25 21:01:36 -0400 2011: I think this commit was ill-advised: http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a03feb9354bda5084f19cc952bc52ba7be89f372 Seems way to implementation-specific and detailed for a user to make heads or tails

Re: [HACKERS] Word-smithing doc changes

2011-11-30 Thread Greg Smith
the risk and potential duration accurately. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Notes on implementing URI syntax for libpq

2011-11-28 Thread Greg Smith
On 11/24/2011 05:21 AM, Alvaro Herrera wrote: A coworker also suggested using a different designator: postgresqli:///path/to/socket:5433/database postgresqli://:5433/database This is not unprecedented. An example is how CUPS handles this problem when connecting printers using URIs:

Re: [HACKERS] Displaying accumulated autovacuum cost

2011-11-28 Thread Greg Smith
On 11/25/2011 08:39 AM, Alvaro Herrera wrote: I was about to commit this when I noticed that the avg values may not be all that representative of reality after all; consider that it's computed across the whole duration of the vacuuming operation, including the index scans ... it'd be possibly

Re: [HACKERS] Displaying accumulated autovacuum cost

2011-11-28 Thread Greg Smith
On 11/25/2011 05:10 PM, Robert Haas wrote: This patch adds a count of the number of buffers dirtied to VACUUM, but it strikes me that it would be useful to add similar tracking to pgBufferUsage. Attached is a patch for that. You can see the new counters through pg_stat_statements or with

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2011-11-28 Thread Greg Smith
On 11/13/2011 12:13 AM, Simon Riggs wrote: On Tue, Nov 1, 2011 at 12:11 PM, Simon Riggssi...@2ndquadrant.com wrote: When I say skip the shutdown checkpoint, I mean remove it from the critical path of required actions at the end of recovery. We can still have a normal checkpoint kicked off at

Re: [HACKERS] splitting plpython into smaller parts

2011-11-28 Thread Greg Smith
On 11/13/2011 09:45 AM, Jan Urbański wrote: The first one factors out some bolerplate related to executing SPI functions in subtransactions (and idea borrowed from pltcl.c). While I haven't looked at the code, this seems worthwhile from the description. The second one is the actual split.

[HACKERS] CommitFest 2011-11 Post-Tryptophan Progress Report

2011-11-28 Thread Greg Smith
With plenty of people in the US returning to work on Monday after a modest break last week, I wanted to put out an updated on the active CommitFest. I just sent out several pleas for help with specific patches where only a limited chunk of the community is really in a good position to test the

Re: [HACKERS] Measuring relation free space

2011-11-28 Thread Greg Smith
On 11/25/2011 04:42 PM, Jeff Janes wrote: It reports space that is free exclusively for updates as being free. In other words, it considers space free even if it is reserved against inserts in deference to fillfactor. This is in contrast to pg_freespace, which only reports space available for

Re: [HACKERS] CommitFest 2011-11 Post-Tryptophan Progress Report

2011-11-28 Thread Greg Smith
On 11/28/2011 05:38 PM, Andres Freund wrote: Unless a major reviewer cries, I will - although not a major reviewer - take a stab thursday if thats fine with you. I intended to use that term to suggest the review job itself could become a major chunk of work, not to try and classify

Re: [HACKERS] Patch: add timing of buffer I/O requests

2011-11-28 Thread Greg Smith
On 11/28/2011 05:51 AM, Robert Haas wrote: On Mon, Nov 28, 2011 at 2:54 AM, Greg Smithg...@2ndquadrant.com wrote: The real problem with this whole area is that we know there are systems floating around where the amount of time taken to grab timestamps like this is just terrible. Assuming the

Re: [HACKERS] Patch: add timing of buffer I/O requests

2011-11-27 Thread Greg Smith
recently was rejected out of hand for the same reason, just not being general enough. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

<    1   2   3   4   5   6   7   8   9   10   >