Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Magnus Hagander
On Thu, Sep 23, 2010 at 04:59, Andrew Dunstan and...@dunslane.net wrote: Also, couldn't we just set up the cvsserver on its own VM with a limited amount of disk space, and not worry too much about any DOS threat? If somebody does do this, block them and reinitialize that server. We could do

Re: [HACKERS] top-level DML under CTEs

2010-09-23 Thread Hitoshi Harada
2010/9/23 Marko Tiikkaja marko.tiikk...@cs.helsinki.fi: On 2010-09-17 4:48 AM, Hitoshi Harada wrote: 2010/9/15 Hitoshi Haradaumi.tan...@gmail.com: Well, I didn't know it is allowed. That would look like the way to go. I made changes to the previous version, so that it avoids to resolve CTE

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Simon Riggs
On Mon, 2010-09-20 at 18:24 -0400, Robert Haas wrote: I feel like that's really nice and simple. There are already 5 separate places to configure to make streaming rep work in a 2 node cluster (master.pg_hba.conf, master.postgresql.conf, standby.postgresql.conf, standby.recovery.conf, password

Re: [HACKERS] Easy way to verify gitignore files?

2010-09-23 Thread Andres Freund
Hi, On Thursday 23 September 2010 02:54:19 Tom Lane wrote: Is there any automated sanity check that we can run to find this sort of problem? I suspect that we probably have got some errors in the .gitignore files, particularly in the back branches, and it would be nice to find them now

Re: [HACKERS] WIP: Triggers on VIEWs

2010-09-23 Thread Dean Rasheed
On 23 September 2010 00:26, Marko Tiikkaja marko.tiikk...@cs.helsinki.fi wrote: On 2010-09-23 1:16 AM, Bernd Helmle wrote: INSERT INTO vfoo VALUES('helmle', 2) RETURNING *;   text  | id +  helmle |  2 (1 row) SELECT * FROM vfoo;  text  | id ---+  bernd |  2 (1 row)

Re: [HACKERS] snapshot generation broken

2010-09-23 Thread Peter Eisentraut
On ons, 2010-09-22 at 12:29 +0300, Peter Eisentraut wrote: On ons, 2010-09-22 at 10:33 +0200, Stefan Kaltenbrunner wrote: It seems that the git move has broken the generation of the automatic snapshot tarballs - has anybody yet looked into what it would take to move those to fetching from

Re: [HACKERS] Per-column collation, work in progress

2010-09-23 Thread Pavel Stehule
Hello I am playing with your patch now. I found a few issues: 1. It's doesn't work with SQL 92 rules for sortby list. I can understand so explicit COLLATE using doesn't work, but the implicit using doesn't work too: CREATE TABLE foo(a text, b text COLLATE cs_CZ.UTF8) SELECT * FROM foo ORDER BY

Re: [HACKERS] Per-column collation, work in progress

2010-09-23 Thread Itagaki Takahiro
On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 3. postgres=# select to_char(current_date,'tmday') collate cs_CZ.utf8;  to_char ──  thursday -- bad result (1 row) COLLATE means collation rather than locale, no? 5. postgres=# create table xy(a text, b

Re: [HACKERS] Per-column collation, work in progress

2010-09-23 Thread Pavel Stehule
2010/9/23 Itagaki Takahiro itagaki.takah...@gmail.com: On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 3. postgres=# select to_char(current_date,'tmday') collate cs_CZ.utf8;  to_char ──  thursday -- bad result (1 row) COLLATE means collation rather

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Heikki Linnakangas
On 23/09/10 11:34, Csaba Nagy wrote: In the meantime our DBs are not able to keep in sync via WAL replication, that would need some kind of parallel WAL restore on the slave I guess, or I'm not able to configure it properly - in any case now we use slony which is working. It would be

Re: [HACKERS] Per-column collation, work in progress

2010-09-23 Thread Peter Eisentraut
On tor, 2010-09-23 at 10:12 +0200, Pavel Stehule wrote: 1. It's doesn't work with SQL 92 rules for sortby list. I can understand so explicit COLLATE using doesn't work, but the implicit using doesn't work too: CREATE TABLE foo(a text, b text COLLATE cs_CZ.UTF8) SELECT * FROM foo ORDER BY

Re: [HACKERS] Per-column collation, work in progress

2010-09-23 Thread Peter Eisentraut
On tor, 2010-09-23 at 17:29 +0900, Itagaki Takahiro wrote: On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 5. postgres=# create table xy(a text, b text collate cs_CZ); ERROR: collation cs_CZ for current database encoding UTF8 does not exist can be there

Re: [HACKERS] top-level DML under CTEs

2010-09-23 Thread Marko Tiikkaja
On 2010-09-23 9:12 AM +0300, Hitoshi Harada wrote: Thanks for the report. Next time, please point the clear problem in English aside the sample. I apologize. The problem was exactly the one pointed out in the email I referred to, so I assumed that further explanation was not necessary. I

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Andrew Dunstan
On 09/23/2010 02:09 AM, Magnus Hagander wrote: On Thu, Sep 23, 2010 at 04:59, Andrew Dunstanand...@dunslane.net wrote: Also, couldn't we just set up the cvsserver on its own VM with a limited amount of disk space, and not worry too much about any DOS threat? If somebody does do this, block

Re: [HACKERS] Standby registration

2010-09-23 Thread Dimitri Fontaine
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: Hmm, that situation can arise if there's a network glitch which leads the standby to disconnect, but the master still considers the connection as alive. When the standby reconnects, the master will see two simultaneous connections

Re: [HACKERS] Standby registration

2010-09-23 Thread Heikki Linnakangas
On 23/09/10 12:32, Dimitri Fontaine wrote: Heikki Linnakangasheikki.linnakan...@enterprisedb.com writes: Hmm, that situation can arise if there's a network glitch which leads the standby to disconnect, but the master still considers the connection as alive. When the standby reconnects, the

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread Pavel Stehule
Hello 2010/9/22 Hitoshi Harada umi.tan...@gmail.com: 2010/9/22 Pavel Stehule pavel.steh...@gmail.com: Hello I found probably hard problem in cooperation with window functions :( tuplesort_begin_datum creates child context inside aggcontext. This context is used for tuplestore. But when

Re: [HACKERS] Standby registration

2010-09-23 Thread Dimitri Fontaine
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: Having mulled through all the recent discussions on synchronous replication, ISTM there is pretty wide consensus that having a registry of all standbys in the master is a good idea. Even those who don't think it's *necessary* for

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Magnus Hagander
On Thu, Sep 23, 2010 at 11:27, Andrew Dunstan and...@dunslane.net wrote: On 09/23/2010 02:09 AM, Magnus Hagander wrote: On Thu, Sep 23, 2010 at 04:59, Andrew Dunstanand...@dunslane.net  wrote: Also, couldn't we just set up the cvsserver on its own VM with a limited amount of disk space,

Re: [HACKERS] Per-column collation, work in progress

2010-09-23 Thread Pavel Stehule
2010/9/23 Peter Eisentraut pete...@gmx.net: On tor, 2010-09-23 at 10:12 +0200, Pavel Stehule wrote: 1. It's doesn't work with SQL 92 rules for sortby list. I can understand so explicit COLLATE using doesn't work, but the implicit using doesn't work too: CREATE TABLE foo(a text, b text

Re: [HACKERS] ask for review of MERGE

2010-09-23 Thread Thom Brown
On 23 September 2010 11:31, Boxuan Zhai bxzhai2...@gmail.com wrote: Dear All, I have just generate a new patch of MERGE command. One main change in this edition is the removal of RASIE ERROR action from MEREG, because its semantics is not well defined yet. I also rewrote the regress test file

Re: [HACKERS] Standby registration

2010-09-23 Thread Heikki Linnakangas
On 23/09/10 12:49, Dimitri Fontaine wrote: Heikki Linnakangasheikki.linnakan...@enterprisedb.com writes: The consensus seems to be use a configuration file called standby.conf. Let's use the ini file format for now [1]. What about automatic registration of standbys? That's not going to fly

Re: [HACKERS] ask for review of MERGE

2010-09-23 Thread Marko Tiikkaja
On 2010-09-23 1:31 PM +0300, Boxuan Zhai wrote: I have just generate a new patch of MERGE command. I haven't followed the discussion very closely, but this part in the regression tests caught my attention: +-- we now have a duplicate key in Buy, so when we join to +-- Stock we will generate

Re: [HACKERS] WIP: Triggers on VIEWs

2010-09-23 Thread Bernd Helmle
--On 23. September 2010 08:59:32 +0100 Dean Rasheed dean.a.rash...@gmail.com wrote: Yes, I agree. To me this is the least surprising behaviour. I think a more common case would be where the trigger computed a value (such as the 'last updated' example). The executor doesn't have any kind of

Re: [HACKERS] Needs Suggestion

2010-09-23 Thread subham
Actually, I used palloc() to set the stack base address. And I am trying to create only a single thread, then also it is causing problem. Actually, I created all the data-structures using palloc(), then I am passing these to the child thread. Even if I make these variables global then also it is

Re: [HACKERS] Needs Suggestion

2010-09-23 Thread subham
So, Can I increase the stack depth limit to a large value ? On 22/09/10 12:03, sub...@cse.iitb.ac.in wrote: Actually, I used palloc() to set the stack base address. And I am trying to create only a single thread, then also it is causing problem. Actually, I created all the data-structures

Re: [HACKERS] BUG #5661: The character encoding in logfile is confusing.

2010-09-23 Thread tkbysh2000
Hi Craig, Almost Japanese software emit log files by encoding of the server the software running on. I'm not sure it is the best way or not, but Japanese users taking it for granted. So I feel that Japanese users would hope that postgre server has same style with other software, cause many

[HACKERS] Latch implementation

2010-09-23 Thread Ganesh Venkitachalam-1
Hi, I've been playing around with measuring the latch implementation in 9.1, and here are the results of a ping-pong test with 2 processes signalling and waiting on the latch. I did three variations (linux 2.6.18, nehalem processor). One is the current one. The second is built on native

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Csaba Nagy
Hi all, Some time ago I was also interested in this feature, and that time I also thought about complete setup possibility via postgres connections, meaning the transfer of the files and all configuration/slave registration to be done through normal backend connections. In the meantime our DBs

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Csaba Nagy
On Thu, 2010-09-23 at 12:02 +0300, Heikki Linnakangas wrote: On 23/09/10 11:34, Csaba Nagy wrote: In the meantime our DBs are not able to keep in sync via WAL replication, that would need some kind of parallel WAL restore on the slave I guess, or I'm not able to configure it properly - in

Re: [HACKERS] Needs Suggestion

2010-09-23 Thread Andrew Dunstan
On 09/22/2010 05:03 AM, sub...@cse.iitb.ac.in wrote: Actually, I used palloc() to set the stack base address. And I am trying to create only a single thread, then also it is causing problem. Did you not understand when people told you this wasn't going to work? Don't create any

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Heikki Linnakangas
On 23/09/10 15:26, Csaba Nagy wrote: Unfortunately it was quite long time ago we last tried, and I don't remember exactly what was bottlenecked. Our application is quite write-intensive, the ratio of writes to reads which actually reaches the disk is about 50-200% (according to the disk stats -

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread Pavel Stehule
Hello I moved a median function to core. + doc part + regress test Regards Pavel Stehule 2010/9/20 Hitoshi Harada umi.tan...@gmail.com: 2010/8/19 Pavel Stehule pavel.steh...@gmail.com: Hello I am sending a prototype implementation of functions median and percentile. This implementation

Re: [HACKERS] Latch implementation

2010-09-23 Thread Robert Haas
On Wed, Sep 22, 2010 at 4:31 PM, Ganesh Venkitachalam-1 gan...@vmware.com wrote: I've been playing around with measuring the latch implementation in 9.1, and here are the results of a ping-pong test with 2 processes signalling and waiting on the latch. I did three variations (linux 2.6.18,

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread Pavel Stehule
sorry little bit fixed patch Pavel 2010/9/23 Pavel Stehule pavel.steh...@gmail.com: Hello I moved a median function to core. + doc part + regress test Regards Pavel Stehule 2010/9/20 Hitoshi Harada umi.tan...@gmail.com: 2010/8/19 Pavel Stehule pavel.steh...@gmail.com: Hello I

Re: [HACKERS] Path question

2010-09-23 Thread Robert Haas
On Tue, Sep 21, 2010 at 12:29 AM, David Fetter da...@fetter.org wrote: On Mon, Sep 20, 2010 at 10:57:00PM -0400, Robert Haas wrote: 2010/9/3 Hans-Jürgen Schönig h...@cybertec.at: On Sep 2, 2010, at 1:20 AM, Robert Haas wrote: I agree. Explicit partitioning may open up some additional

Re: [HACKERS] Latch implementation

2010-09-23 Thread Heikki Linnakangas
On 22/09/10 23:31, Ganesh Venkitachalam-1 wrote: I've been playing around with measuring the latch implementation in 9.1, and here are the results of a ping-pong test with 2 processes signalling and waiting on the latch. I did three variations (linux 2.6.18, nehalem processor). One is the

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Bruce Momjian
Magnus Hagander wrote: I assume most buildfarm clients are off static IPs (at least as seen from the servers - they may be behind a NAT device, but that one having static out)? If so, it seems simply easier to use pserver... Yes, I think we should have a VM. Is that so hard to do in

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Andrew Dunstan
On 09/23/2010 09:55 AM, Bruce Momjian wrote: Stupid question, but can't we just create a CVSROOT fed from git, and use the normal CVS server to feed sites? Where is it going to get the ,v files that CVS uses from? git-cvsserver emulates a CVS server from git. It doesn't create a CVS

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Bruce Momjian
Andrew Dunstan wrote: On 09/23/2010 09:55 AM, Bruce Momjian wrote: Stupid question, but can't we just create a CVSROOT fed from git, and use the normal CVS server to feed sites? Where is it going to get the ,v files that CVS uses from? git-cvsserver emulates a CVS server

Re: [HACKERS] security label support, revised

2010-09-23 Thread Stephen Frost
Robert, First off, thanks alot for working on this. My apologies for not having time to help out. A few minor comments: * Robert Haas (robertmh...@gmail.com) wrote: Most of the contents of the new documentation section on external security providers seemed irrelevant to me, which I guess I

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Magnus Hagander
On Thu, Sep 23, 2010 at 16:11, Bruce Momjian br...@momjian.us wrote: Andrew Dunstan wrote: On 09/23/2010 09:55 AM, Bruce Momjian wrote: Stupid question, but can't we just create a CVSROOT fed from git, and use the normal CVS server to feed sites? Where is it going to get the ,v

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread David Fetter
On Thu, Sep 23, 2010 at 04:38:27PM +0200, Magnus Hagander wrote: On Thu, Sep 23, 2010 at 16:11, Bruce Momjian br...@momjian.us wrote: Andrew Dunstan wrote: On 09/23/2010 09:55 AM, Bruce Momjian wrote: Stupid question, but can't we just create a CVSROOT fed from git, and use the normal

Re: [HACKERS] Serializable Snapshot Isolation

2010-09-23 Thread Kevin Grittner
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 23/09/10 02:14, Kevin Grittner wrote: There is a rub on the other point, though. Without transaction information you have no way of telling whether TN committed before T0, so you would need to assume that it did. So on this

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Andrew Dunstan
On 09/23/2010 10:58 AM, David Fetter wrote: Back to a question you asked earlier, what exactly still depends on CVS right now, as in which buildfarm animals, what parts of the NLS processes? Also as you asked earlier, what else? At least one buildfarm member, spoonbill, is known to have

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: So, I found (with some helpful hints from Robert who caught the final nail in the coffin) a good reason why we really can't run a git-cvsserver globally. Any user can point their cvs client at the repository. And check out an arbitrary branch, tag

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Magnus Hagander
On Thu, Sep 23, 2010 at 17:16, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: So, I found (with some helpful hints from Robert who caught the final nail in the coffin) a good reason why we really can't run a git-cvsserver globally. Any user can point their cvs

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread David Fetter
On Thu, Sep 23, 2010 at 11:17:35AM -0400, Andrew Dunstan wrote: On 09/23/2010 10:58 AM, David Fetter wrote: Back to a question you asked earlier, what exactly still depends on CVS right now, as in which buildfarm animals, what parts of the NLS processes? Also as you asked earlier, what

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Andrew Dunstan
On 09/23/2010 11:18 AM, Magnus Hagander wrote: On Thu, Sep 23, 2010 at 17:16, Tom Lanet...@sss.pgh.pa.us wrote: Magnus Hagandermag...@hagander.net writes: So, I found (with some helpful hints from Robert who caught the final nail in the coffin) a good reason why we really can't run a

Re: [HACKERS] Latch implementation

2010-09-23 Thread Simon Riggs
On Wed, 2010-09-22 at 13:31 -0700, Ganesh Venkitachalam-1 wrote: Hi, I've been playing around with measuring the latch implementation in 9.1, and here are the results of a ping-pong test with 2 processes signalling and waiting on the latch. I did three variations (linux 2.6.18, nehalem

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Simon Riggs
On Wed, 2010-09-22 at 13:00 -0400, Robert Haas wrote: I think it should be a separate config file, and I think it should be a config file that can be edited using DDL commands as you propose. But it CAN'T be a system catalog, because, among other problems, that rules out cascading slaves,

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Stefan Kaltenbrunner
David Fetter wrote: On Thu, Sep 23, 2010 at 11:17:35AM -0400, Andrew Dunstan wrote: On 09/23/2010 10:58 AM, David Fetter wrote: Back to a question you asked earlier, what exactly still depends on CVS right now, as in which buildfarm animals, what parts of the NLS processes? Also as you asked

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Magnus Hagander
On Thu, Sep 23, 2010 at 17:32, Andrew Dunstan and...@dunslane.net wrote: On 09/23/2010 11:18 AM, Magnus Hagander wrote: On Thu, Sep 23, 2010 at 17:16, Tom Lanet...@sss.pgh.pa.us  wrote: Magnus Hagandermag...@hagander.net  writes: So, I found (with some helpful hints from Robert who caught

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: On Thu, Sep 23, 2010 at 17:16, Tom Lanet...@sss.pgh.pa.us wrote: I'm still wondering why we don't simply lobotomize git-cvsserver to refuse requests to check out anything except the active branch tips. Are we sure that's going to stop the DOS issue?

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: ISTM that we can have a system catalog and still have cascading slaves. If we administer the catalog via the master, why can't we administer all slaves, however they cascade, via the master too? What other problems are there that mean we *must* have a

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Thu, Sep 23, 2010 at 17:32, Andrew Dunstan and...@dunslane.net wrote: Are we sure that's going to stop the DOS issue? As long as it's done right, I don't see how it wouldn't. There might be a cleaner way to do it, but after a moment's inspection

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Simon Riggs
On Thu, 2010-09-23 at 11:43 -0400, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: ISTM that we can have a system catalog and still have cascading slaves. If we administer the catalog via the master, why can't we administer all slaves, however they cascade, via the master too?

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 11:32 AM, Simon Riggs si...@2ndquadrant.com wrote: On Wed, 2010-09-22 at 13:00 -0400, Robert Haas wrote: I think it should be a separate config file, and I think it should be a config file that can be edited using DDL commands as you propose. But it CAN'T be a system

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: On Thu, 2010-09-23 at 11:43 -0400, Tom Lane wrote: Well, for one thing, how do you add a new slave? If its configuration comes from a system catalog, it seems that it has to already be replicating before it knows what its configuration is. At the

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 12:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: On Thu, 2010-09-23 at 11:43 -0400, Tom Lane wrote: Well, for one thing, how do you add a new slave?  If its configuration comes from a system catalog, it seems that it has to already

Re: [HACKERS] Path question

2010-09-23 Thread Hans-Jürgen Schönig
On Sep 23, 2010, at 3:29 PM, Robert Haas wrote: On Tue, Sep 21, 2010 at 12:29 AM, David Fetter da...@fetter.org wrote: On Mon, Sep 20, 2010 at 10:57:00PM -0400, Robert Haas wrote: 2010/9/3 Hans-Jürgen Schönig h...@cybertec.at: On Sep 2, 2010, at 1:20 AM, Robert Haas wrote: I agree. Explicit

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: Now, admittedly, in more complex topologies, and especially if you're using configuration options that pertain to the behavior of disconnected standbys (e.g. wait for them, or retain WAL for them), you're going to need to adjust the configs. But I

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 12:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Um ... so how does this standby know what master to connect to, what password to offer, etc?  I don't think that pass down parameters after connecting is likely to cover anything but

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 1:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 12:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Um ... so how does this standby know what master to connect to, what password to offer, etc?  I don't think that

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread Aidan Van Dyk
On Thu, Sep 23, 2010 at 11:49 AM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Thu, Sep 23, 2010 at 17:32, Andrew Dunstan and...@dunslane.net wrote: Are we sure that's going to stop the DOS issue? As long as it's done right, I don't see how it wouldn't.

Re: [HACKERS] Path question

2010-09-23 Thread Robert Haas
2010/9/23 Hans-Jürgen Schönig h...@cybertec.at: sorry for not getting back to you sooner. i am currently on the road for some days. we got the top 3 things fixed already. however, some code seems to be relying on a sorted list somewhere(???). we are in the process of sorting out most of the

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Josh Berkus
On 9/22/10 6:00 PM, Tom Lane wrote: I think you missed the point of my response, which is that there are easily 106 more-pressing things to work on than the size of timetz. Do you know of any actual use cases for it? It would be a good project to add to the list of easy TODOs to get started

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Bruce Momjian
Josh Berkus wrote: On 9/22/10 6:00 PM, Tom Lane wrote: I think you missed the point of my response, which is that there are easily 106 more-pressing things to work on than the size of timetz. Do you know of any actual use cases for it? It would be a good project to add to the list of

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Csaba Nagy
On Thu, 2010-09-23 at 16:18 +0300, Heikki Linnakangas wrote: There's a program called pg_readahead somewhere on pgfoundry by NTT that will help if it's the single-threadedness of I/O. Before handing the WAL file to the server, it scans it through and calls posix_fadvise for all the blocks

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Csaba Nagy
On Thu, 2010-09-23 at 11:43 -0400, Tom Lane wrote: What other problems are there that mean we *must* have a file? Well, for one thing, how do you add a new slave? If its configuration comes from a system catalog, it seems that it has to already be replicating before it knows what its

Re: [HACKERS] Latch implementation

2010-09-23 Thread Ganesh Venkitachalam-1
Attached is the current implementation redone with poll. It lands at around 10.5 usecs, right above pipe, but better than the current implementation. As to the other questions: yes, this would matter for sync replication. Cosider an enterprise use case with 10Gb network SSDs (not at all

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 1:29 PM, Bruce Momjian br...@momjian.us wrote: Josh Berkus wrote: On 9/22/10 6:00 PM, Tom Lane wrote: I think you missed the point of my response, which is that there are easily 106 more-pressing things to work on than the size of timetz. Do you know of any actual

Re: [HACKERS] security label support, revised

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 10:21 AM, Stephen Frost sfr...@snowman.net wrote: * Robert Haas (robertmh...@gmail.com) wrote: Most of the contents of the new documentation section on external security providers seemed irrelevant to me, which I guess I can only blame myself for since I was the one who

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Heikki Linnakangas
On 23/09/10 20:03, Tom Lane wrote: Robert Haasrobertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 12:52 PM, Tom Lanet...@sss.pgh.pa.us wrote: Um ... so how does this standby know what master to connect to, what password to offer, etc? I don't think that pass down parameters after

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread Hitoshi Harada
2010/9/23 Pavel Stehule pavel.steh...@gmail.com: Hello 2010/9/22 Hitoshi Harada umi.tan...@gmail.com: 2010/9/22 Pavel Stehule pavel.steh...@gmail.com: Hello I found probably hard problem in cooperation with window functions :( maybe I was confused. I found a other possible problems. The

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 1:29 PM, Bruce Momjian br...@momjian.us wrote: Josh Berkus wrote: It would be a good project to add to the list of easy TODOs to get started with. Except for the pg_upgrade issue. Which is a big except. Yeah. That

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Bruce Momjian
Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 1:29 PM, Bruce Momjian br...@momjian.us wrote: Josh Berkus wrote: It would be a good project to add to the list of easy TODOs to get started with. Except for the pg_upgrade issue. Which is a big

Re: [HACKERS] security label support, revised

2010-09-23 Thread Stephen Frost
* Robert Haas (robertmh...@gmail.com) wrote: The point is that SECURITY LABEL, as coded, will fail utterly unless there is a label provider loaded. So you can't actually run it and check the results in the catalog without loading a contrib module. Urgh, yes, point. Well, we could test that

Re: [HACKERS] .gitignore files, take two

2010-09-23 Thread Magnus Hagander
On Tue, Sep 21, 2010 at 22:11, Tom Lane t...@sss.pgh.pa.us wrote: I wrote: Magnus Hagander mag...@hagander.net writes: Do we know what the exact pattern would be for .sl and .dylib? Are they following the same basic pattern of .sl.major.minor? Yes, they'll be just the same --- Makefile.shlib

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread Pavel Stehule
2010/9/23 Hitoshi Harada umi.tan...@gmail.com: 2010/9/23 Pavel Stehule pavel.steh...@gmail.com: Hello 2010/9/22 Hitoshi Harada umi.tan...@gmail.com: 2010/9/22 Pavel Stehule pavel.steh...@gmail.com: Hello I found probably hard problem in cooperation with window functions :( maybe I was

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 1:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 1:29 PM, Bruce Momjian br...@momjian.us wrote: Josh Berkus wrote: It would be a good project to add to the list of easy TODOs to get started with. Except for

Re: [HACKERS] security label support, revised

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 2:06 PM, Stephen Frost sfr...@snowman.net wrote: * Robert Haas (robertmh...@gmail.com) wrote: The point is that SECURITY LABEL, as coded, will fail utterly unless there is a label provider loaded.  So you can't actually run it and check the results in the catalog

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread David Fetter
On Thu, Sep 23, 2010 at 08:27:38PM +0200, Pavel Stehule wrote: 2010/9/23 Hitoshi Harada umi.tan...@gmail.com: 2010/9/23 Pavel Stehule pavel.steh...@gmail.com: Hello 2010/9/22 Hitoshi Harada umi.tan...@gmail.com: 2010/9/22 Pavel Stehule pavel.steh...@gmail.com: Hello I found

Re: [HACKERS] Easy way to verify gitignore files?

2010-09-23 Thread Dimitri Fontaine
Tom Lane t...@sss.pgh.pa.us writes: However, it seems that git isn't so willing to tell you about gitignore patterns that cover too much, i.e. match files that are already in the repository. It seems to me that git-ls-files is what you want here :

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread Pavel Stehule
2010/9/23 David Fetter da...@fetter.org: On Thu, Sep 23, 2010 at 08:27:38PM +0200, Pavel Stehule wrote: 2010/9/23 Hitoshi Harada umi.tan...@gmail.com: 2010/9/23 Pavel Stehule pavel.steh...@gmail.com: Hello 2010/9/22 Hitoshi Harada umi.tan...@gmail.com: 2010/9/22 Pavel Stehule

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Alvaro Herrera
Excerpts from Robert Haas's message of jue sep 23 14:33:06 -0400 2010: I'm worried about how we're going to manage that. First, as pg_upgrade becomes more mature, the penalty for breaking on-disk compatibility gets a LOT bigger. I'd like to think that the next time we break on-disk

pg_upgrade pain; was Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Bruce Momjian
Robert Haas wrote: On Thu, Sep 23, 2010 at 1:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Sep 23, 2010 at 1:29 PM, Bruce Momjian br...@momjian.us wrote: Josh Berkus wrote: It would be a good project to add to the list of easy TODOs to get

Re: [HACKERS] Serializable Snapshot Isolation

2010-09-23 Thread Heikki Linnakangas
On 23/09/10 18:08, Kevin Grittner wrote: Less important than any of the above, but still significant in my book, I fear that conflict recording and dangerous structure detection could become very convoluted and fragile if we eliminate this structure for committed transactions. Conflicts among

Re: pg_upgrade pain; was Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Joshua D. Drake
On Thu, 2010-09-23 at 15:20 -0400, Bruce Momjian wrote: decide to break it when we run into a feature that we really want that can't be had any other way? If we want to make breaking on-disk compatibility something that only happens every 5 years or so, we had better give people - I

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Simon Riggs
On Thu, 2010-09-23 at 13:07 -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: Now, admittedly, in more complex topologies, and especially if you're using configuration options that pertain to the behavior of disconnected standbys (e.g. wait for them, or retain WAL for them),

Re: pg_upgrade pain; was Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Bruce Momjian
Joshua D. Drake wrote: On Thu, 2010-09-23 at 15:20 -0400, Bruce Momjian wrote: decide to break it when we run into a feature that we really want that can't be had any other way? If we want to make breaking on-disk compatibility something that only happens every 5 years or so, we had

[HACKERS] git cherry-pick timestamping issue

2010-09-23 Thread Tom Lane
So my first attempt at using git cherry-pick didn't go so well. The commit in master looks like commit ee63981c1fe26299162b9c7f1218d7e3ef802409 Author: Tom Lane t...@sss.pgh.pa.us Date: Thu Sep 23 15:34:56 2010 -0400 Avoid sharing subpath list structure when flattening nested AppendRels.

Re: [HACKERS] git cherry-pick timestamping issue

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Apparently somebody's confused between local and GMT time somewhere in there. Ouch. That rather sucks. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers

Re: [HACKERS] Configuring synchronous replication

2010-09-23 Thread Robert Haas
On Thu, Sep 23, 2010 at 3:46 PM, Simon Riggs si...@2ndquadrant.com wrote: Well, its not at all hard to see how that could be configured, because I already proposed a simple way of implementing parameters that doesn't suffer from those problems. My proposal did not give roles to named standbys

Re: [HACKERS] Serializable Snapshot Isolation

2010-09-23 Thread Kevin Grittner
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 23/09/10 18:08, Kevin Grittner wrote: Less important than any of the above, but still significant in my book, I fear that conflict recording and dangerous structure detection could become very convoluted and fragile if we

[HACKERS] is there a reason we can't copy from a view?

2010-09-23 Thread Josh Berkus
... other than it just got forgotten? dolszewski=# create view meh as select * from pg_tables; CREATE VIEW dolszewski=# copy meh to stdout; ERROR: cannot copy from view meh HINT: Try the COPY (SELECT ...) TO variant. dolszewski=# copy (select * from meh) to stdout;

Re: [HACKERS] is there a reason we can't copy from a view?

2010-09-23 Thread Tom Lane
Josh Berkus j...@agliodbs.com writes: ... other than it just got forgotten? We've been over that ground before. IIRC the conclusion was that letting COPY TO pretend that a view is a table is a bad idea because then people would complain about COPY FROM not working for it. You can use

Re: [HACKERS] git cherry-pick timestamping issue

2010-09-23 Thread David E. Wheeler
On Sep 23, 2010, at 1:02 PM, Robert Haas wrote: On Thu, Sep 23, 2010 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Apparently somebody's confused between local and GMT time somewhere in there. Ouch. That rather sucks. Obviously, all committers must now relocate to the UK. Best, David

Re: [HACKERS] git cherry-pick timestamping issue

2010-09-23 Thread Thom Brown
On 23 September 2010 22:20, David E. Wheeler da...@kineticode.com wrote: On Sep 23, 2010, at 1:02 PM, Robert Haas wrote: On Thu, Sep 23, 2010 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Apparently somebody's confused between local and GMT time somewhere in there. Ouch.  That rather

Re: [HACKERS] git cherry-pick timestamping issue

2010-09-23 Thread Joshua D. Drake
On Thu, 2010-09-23 at 22:22 +0100, Thom Brown wrote: On 23 September 2010 22:20, David E. Wheeler da...@kineticode.com wrote: On Sep 23, 2010, at 1:02 PM, Robert Haas wrote: On Thu, Sep 23, 2010 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Apparently somebody's confused between local

  1   2   >